column to column comparision

[#1]

Hi,

Pls let me know is there any option in qlikview to compare of two columns like this

=If(column(1)=column(2),1.0)

Thanks,

[Miguel_Angel_Baeyens]

Hello,

Your code will work. Bear in mind that in pivot and straight tables, columns are referred to expressions, not dimensions. Your code will read "if value in first expressions for this row equals to value in second expression, then 1, otherwise 0".

Regards.

[#3]

Thanks Miguel, your are right..

Thanks,