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!
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)..
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
Use Expression: =count(total distinct Date)
That´s it!!! Thanks very much
Retrieving data ...