Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Valued Contributor

Re: create a pivot table with a count of Dockets per Store

Can you upload some example data ?

micheledenardi
Valued Contributor

Re: create a pivot table with a count of Dockets per Store

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

Not applicable

Re: create a pivot table with a count of Dockets per Store

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
Esteemed Contributor II

Re: create a pivot table with a count of Dockets per Store

or just

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

Not applicable

Re: create a pivot table with a count of Dockets per Store

Vineeth,

Thanks,

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

Thanks.

Regards Dean.

oknotsen
Honored Contributor III

Re: create a pivot table with a count of Dockets per Store

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!