Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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

Re: Row value comparision of two columns

Add Calculated Dimension:

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

Replace the Special with whatever "Special" do you want

Not applicable

Re: Row value comparision of two columns

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.

Re: Row value comparision of two columns

Try

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

Community Browser