Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Row value comparision of two columns

Hi,

I have two columns in the same table customer and currency as show below

customer, curreny

A           , -

B           ,1$

C           ,1r

1            ,1r

2            ,1$

3           ,1r

-           ,1$

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.....

3 Replies
robert_mika
Master III
Master III

Add Calculated Dimension:

=if(customer=1 AND curreny='1r' OR curreny='','Special',0)

Replace the Special with whatever "Special" do you want

Not applicable
Author

Hi Robert,

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.

robert_mika
Master III
Master III

Try

=IF(ISNUM(customer) AND curreny='1r' OR curreny='','Special',0)