Discussion Board for collaboration related to Qlik Education.
I have two columns in the same table customer and currency as show below
A , -
I need to replace all null and numeric values in customer based on currency
example if customer=1 and currency=1$ or null i need to show a special instead of number or null in customer class
can anyone suggest how to achieve this.
Thanks in advance.....
Add Calculated Dimension:
=if(customer=1 AND curreny='1r' OR curreny='','Special',0)
Replace the Special with whatever "Special" do you want
I want this condition to be applied for all numeric and null values in customer field depending on curreny value can you please give example how to handle it.
=IF(ISNUM(customer) AND curreny='1r' OR curreny='','Special',0)