topic Re: DIMENSION CALCULATION WITH DATES AND DAYS in QlikView

DIMENSION CALCULATION WITH DATES AND DAYS

Mon, 04 Sep 2017 12:55:46 GMT

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.

Re: DIMENSION CALCULATION WITH DATES AND DAYS

Anonymous — Mon, 04 Sep 2017 17:50:37 GMT

Hi Benjamin,

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

Thank you,

Qlik Community Team

Re: DIMENSION CALCULATION WITH DATES AND DAYS

sergio0592 — Mon, 04 Sep 2017 18:11:18 GMT

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')