DIMENSION CALCULATION WITH DATES AND DAYS

[#1]

GOOD, I AM CONSULTING A COLUMN OF CALCULATED VALUES, AS IS SHOWN IN THE IMAGE, THE PROBLEM THAT AT THE TIME OF MAKING THE COMPARATIVE I HAVE THIS PROBLEM.

IN COLUMN "A" SHOWS THE DAYS TRANSCURRED FROM TODAY TO THE DATE SHOWN IN THE PREVIOUS COLUMN.

IN COLUMN "B" THE MINIMUM VALUE OF THAT GROUP IS SHOWN.

IN THE COLUMN "C" SHOULD BE SHOWN IF IT IS THE SAME OR NOT ... AND THE PROBLEM IS THAT SOME ROWS COMPARE WELL AND OTHER NOT ... AS YOU CAN SEE IN THE IMAGE.

THAT COULD BE OCCURRING.

[Anonymous]

Hi Benjamin,

In the future, please do not post using all capital letters.

Thank you,

Qlik Community Team

[sergio0592]

So,  what is the formula in your column C? Because should works with :

Using labels : =if(A=B,'SI','NO')

Using columnno() : =if(ColumnNo(5)=ColumnNo(6),'SI','NO')