Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Re: Add a Total Value to the Pivot Table

!Hi Anyone,

I have the pivot table with totals now.

How can I get the percentage by programs?

I have added a expression =count([G-code])/Count(TOTAL [G-code]) but this gives the percentage by taking the overall total.

For example for G-Code A the percentage I want is 1/1=100% but the above expression gives 1/8 which is 0.125.

Any help?

I tried various combinations of Aggr (my level) but no use.

Thanks!

3 Replies
Highlighted

May be try this

=Count([G-code])/Count(TOTAL <Program> [G-code])

Capture.PNG

Highlighted
Specialist
Specialist

Please check the attachment.

Highlighted
Contributor III
Contributor III

Thanks @Sunny Talwar.

It worked.