Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Question, I am new to qlikview, i am wanting to create a pivot table with a count of dockets per store, Store being a dimension of the pivot.
I can create the pivot OK, I can get the count of docket numbers per person /per store OK.
What I can't do is get the % of dockets per person per store.
I can get the total count of dockets per store using
sum(aggr(count(distinct [Retail-DocketTY]),Warehouse_Store))
but it only returns the number for one of the entries
How can I return the value on every line of the pivot so I can use it to calculate the relative % of the dimension total?
Thanks in advance
Can you upload some example data ?
Use this expression:
aggr( Nodistinct sum(Sales),Warehouse)
Michele,
Thanks, That was magnificent.
You put me on the correct path.
The formula I had to use was
“aggr( Nodistinct Count(distinct ),Warehouse_Store)”
but I don’t think I would have got there without your help.
Thanks again.
Regards Dean.
or just
COUNT( TOTAL <Warehouse_Store> DISTINCT [Retail-DocketTY] )
Vineeth,
Thanks,
This solution is a bit easier to understand, Works Great.
Thanks.
Regards Dean.
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .