compare value within columns

[beck_bakytbek]

Hi Folks,

i got a question: how can i compare value within 2 columns, i solved a part of my issue by using this expression:

if( column1 = column2, 'yes','no') as compare

but what if, i want to compare the value which i loaded yesterday with value wich i loaded today and all those values i compare in the form: column1 vs column2.

For more clarity, please see the attached screenshot.

Does anybody have any ideas?

Thanks a lot

Beck

[passionate]

Hi Beck,

Thanks but, there is key column missing in the screenshot.

Regards,

Pankaj

[beck_bakytbek]

Hi Marina,

no i did not achieve any results

[marinadorcassio1]

May you be more precise ?

[beck_bakytbek]

Hi Marina,

thanks a lot for your Feedback, as you see my previous attached file (screenshot), i wanted to compare the values in both columns, normaly we compare in qlik sense the values within rows and columns by using of functions: above (), but what if i compare my value in column 1: for instance the number: 4 (row = 1) with the value in column 2: the number 4 (row = 5), how can i compare those both values?

thanks a lot