This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a Pivot Table where there is something like this:
But if I contract all, I see:
- 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?
could you please upload qvw?
When you are using DISTINCT , It will give you count of only Distinct Account which is in your case
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,
Please try with removing distinct word.
Hope it work for you.
Pivot Table: Sum of Rows?
This is the same thread by you.
or you can use straight table instead and check sum (no of rows) after selecting expression on expression tab
In your chart have Account are dimension , then you will use count(Account) expression fine. for your requirement.
Kindly find the attachment file.
If you need 'sum of rows' in a pivot table,use this for your expression:
Sum(Aggr(COUNT (DISTINCT ACCOUNT), PRODUCT))
Hi Jonathan, I found your solution very helpful, thanks for that btw.
I do have a different issue now. I wish to implement the aggr function into a Qlik Sense application.
this makes things very difficult for me as the users decide on which dimensions they wish to see their totals.
Is there a way to make the aggr expression dynamic? lets say the users drags in PRODUCT and ACCOUNT,
the aggr function must then cater for both the dimensions.
It's a bit rocket sciency for me.
help will be appreciated.