Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

create a pivot table with a count of Dockets per Store

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

Capture QLIK grid.JPG

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

6 Replies
micheledenardi
Specialist II
Specialist II

Can you upload some example data ?

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
micheledenardi
Specialist II
Specialist II

Use this expression: 

aggr( Nodistinct sum(Sales),Warehouse)

2017-05-29 09_23_00-QlikView x64 Personal Edition - [C__Users_Michele.Denardi_Desktop_test.qvw_].png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

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.

vinieme12
Champion III
Champion III

or just

COUNT( TOTAL <Warehouse_Store DISTINCT  [Retail-DocketTY] )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Vineeth,

Thanks,

This solution is a bit easier to understand, Works Great.

Thanks.

Regards Dean.

oknotsen
Master III
Master III

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 .

May you live in interesting times!