Discussion board where members can get started with QlikView.
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
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)
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.
COUNT( TOTAL <Warehouse_Store> DISTINCT [Retail-DocketTY] )
This solution is a bit easier to understand, Works Great.
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 .