topic column to column comparision in QlikView

column to column comparision

Thu, 07 Oct 2010 13:07:04 GMT

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,

column to column comparision

Miguel_Angel_Baeyens — Thu, 07 Oct 2010 13:26:19 GMT

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.

column to column comparision

Fri, 08 Oct 2010 12:31:10 GMT

Thanks Miguel, your are right..

Thanks,