How to use the IIF() Function as a Filter in Birst

Rupinder Singh

I am trying to use the result from the IIF() function in the Where clause but Birst simply says Unable to apply filter to measure when I try to do so.

My IIF Function has multiple nested IIFs. Even if I try to save it as a Global Attribute, it still doesn't let me put it in the where clause.

[AGG_FACT_HH_SNAPSHOT_DATE: # Distinct SHIPTO_CUSTOMER_NO] WHERE iif(SOME CONDITION,1,0) = 1

Tamas Molnar

Hi, IIF is a function that has 3 parameters, as it is there, but measure even with where clause needs to be the block it determinates, like:

IIf( <SOME CONDITION>

, [AGG_FACT_HH_SNAPSHOT_DATE: # Distinct SHIPTO_CUSTOMER_NO]

, <0 or other measurement or the same measurement with other where clause>

)