Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There, I have a PivotTable with two dimensions. Now I want to have the number of Dates that I select in each cell. I attached a screenshot and the Qlikview-file.
Thanks very much in advance!
Use Expression: =count(total distinct Date)
if the field have those dates oly itt ll be shown
if the field is not associated with that date it wont show
use getselectedCount(Date) instead of count(Date)..
Use Expression: =count(total distinct Date)
That´s it!!! Thanks very much
Thats a very good hint, but I couldn´t use it, because I didn´t select the date directly. I have forgotten to mention it. but thanks very much