topic Count of Rows in QlikView

Count of Rows

Mon, 05 Nov 2012 07:52:57 GMT

Hi everynoe,

I need to display count of rows of pivot table in title of same chart. Please suggest how to achieve this with and without macros.

Many thanks,

Murali

Re: Count of Rows

amars — Mon, 05 Nov 2012 08:01:56 GMT

Hi,

NoOfRows( ['TableName ' ] ) in the Caption

Thanks

Amar

Re: Count of Rows

jagan — Mon, 05 Nov 2012 08:50:44 GMT

Hi Murali,

Please find attached file for solution. Hope it helps you.

Regards,

Jagan.

Re: Count of Rows

Mon, 05 Nov 2012 09:20:47 GMT

Thanks a lot. Aggregation function gives right result.

/Murali

Re: Count of Rows

Tue, 06 Nov 2012 10:45:55 GMT

Hi Jagan,

The above test.qvw is showing the no. of rows at lowest level i.e. Item Type. But in Pivot Table if we are at Country level the expression should show only 4 (Country wise no. of rows) and if we expend the table at Item Type level then it should show 10(Item Type wise no. of rows).

Is is possible to show like this.

Thanks & Regards

Apurva

Re: Count of Rows

jagan — Tue, 06 Nov 2012 11:02:23 GMT

Hi Apurva,

Try this expression

='Total Rows =' & If(Dimensionality()= 2, Sum(Aggr(1, Country, [Item Type])), Sum(Aggr(1, Country)))

Hope it helps you.

Regards,

Jagan.

Re: Count of Rows

Tue, 06 Nov 2012 11:10:37 GMT

Hi Jagan,

its not working it is showing only 4 for both dimensions. Please try in your application and send to me.

Thanks & Regards

Apurva

Re: Count of Rows

jagan — Tue, 06 Nov 2012 11:39:08 GMT

Hi Apurva,

The Dimensionality() returns empty value for Total Row, and also for Pivot table there is no option for "Sum of Rows" in Expression tab. So, this may not work for Pivot table. So, there is no way to track the dimension level. But we can do this by show and hide dimension buttons and track the dimension level. PFA file.

Regards,

Jagan.