Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Date in PivotTable

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!

img_170_a.jpg

Labels (1)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

Use Expression:  =count(total distinct Date)

View solution in original post

5 Replies
gautik92
Specialist III
Specialist III

if the field have those dates oly itt ll be shown

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

Not applicable
Author

Capture1.JPGuse getselectedCount(Date) instead of count(Date)..Capture.JPG

tresB
Champion III
Champion III

Use Expression:  =count(total distinct Date)

Not applicable
Author

That´s it!!! Thanks very much

Not applicable
Author

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