Count of Rows in Pivot Table

sjhussain — Tue, 14 Apr 2015 16:55:17 GMT

Hello,

We are having problem in displaying the Count of Rows in our Pivot Table.

The equation we are using for Days is

=sum(aggr(if($(vSTotal),1,0),ass_name,nQueryDate))

$(vSTotal) is just a dynamic variable having conditional expression e.g. (SD2_dos_moving >=1 and SD2_dos_moving <=200 and SD3_dos_moving = 0)

We want to display the following:

* Count of the Assets where Days are 0

* Do not display the Assets where Days are 0

Also the assets are linked to other tables they will be used in other charts. So how is it possible to display the same assets as part of other charts?

Will appreciate if someone can really assist us with this.

Thanks in advance.

topic Count of Rows in Pivot Table in QlikView

Count of Rows in Pivot Table