Count Date in PivotTable

[#1]

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!

[gautik92]

if the field have those dates oly itt ll be shown

if the field is not associated with that date it wont show

[#3]

use getselectedCount(Date) instead of count(Date)..

[tresesco · Accepted solution]

Use Expression:  =count(total distinct Date)

[#5]

That´s it!!! Thanks very much

[#6]

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