topic Count Date in PivotTable in QlikView

Count Date in PivotTable

Thu, 24 Sep 2015 10:00:44 GMT

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!

Re: Count Date in PivotTable

gautik92 — Thu, 24 Sep 2015 10:04:50 GMT

if the field have those dates oly itt ll be shown

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

Re: Count Date in PivotTable

Thu, 24 Sep 2015 10:04:59 GMT

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

Re: Count Date in PivotTable

tresB — Thu, 24 Sep 2015 10:12:03 GMT

Use Expression: =count(total distinct Date)

Re: Count Date in PivotTable

Thu, 24 Sep 2015 10:15:43 GMT

That´s it!!! Thanks very much

Re: Count Date in PivotTable

Thu, 24 Sep 2015 10:17:20 GMT

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