topic Re: Pivot Table: Sum of Rows? in QlikView

Pivot Table: Sum of Rows?

Wed, 23 Jul 2014 04:18:36 GMT

Hello,

I have a Pivot Table where there is something like this:

But if I contract all, I see:

Where:

- Product: Dimension

- Account: Dimension

- Count: Expression

The Expression Count is this:

COUNT (DISTINCT ACCOUNT)

So it counts the distinct accounts for every product

That's why it shows me 5 instead of 7...

I'd like to show the value as a Sum of Rows (like in Simple Table, but I need to use this Pivot Table), in order to show me 7.

Do you know how could I do this?

Thank you!

er_mohit — Wed, 23 Jul 2014 04:32:53 GMT

Try this expression

Count(TOTAL <PRODUCT> ACCOUNT)

PrashantSangle — Wed, 23 Jul 2014 04:37:00 GMT

Hi,

When you are using DISTINCT , It will give you count of only Distinct Account which is in your case

10,20,30,40,50

Therefore it is showing you Count =5,

If you want to Count of All account even if they are repeated then try with

Simple count(ACCOUNT) instead of trying with count(distinct ACCOUNT).

Or you can try with Aggr() also,

Like,

AGGR(count(distinct ACCOUNT),PRODUCT)

Regards,