Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

DIMENSION CALCULATION WITH DATES AND DAYS

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.

Sin título.png


THAT COULD BE OCCURRING.

2 Replies
Highlighted
Community Manager
Community Manager

Re: DIMENSION CALCULATION WITH DATES AND DAYS

Hi Benjamin,

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

Thank you,

Qlik Community Team

Highlighted
Valued Contributor II

Re: DIMENSION CALCULATION WITH DATES AND DAYS

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