Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Relative % in Pivot Table

I just want to create an expression that will provide be a % of the total count of presentations given per the week dimension. 

I am counting the number of Presentations that are certaion plan types in a given week. 

Below is the formula I am using and I am having problems. 

count

({$<PlanDescription = {'*Life*','*Senior*'}-{'*Paid Up*','*Select*'}>} Distinct PresentationID)/

count({$<PlanDescription = {'*Life*','*Senior*'}-{'*Paid Up*','*Select*'}>} Distinct total <Week> PresentationID

I attached an excel verion of my pivot table in QV...my percentages appear to be off...

Any suggestions would be greatly appreciated.  Thankd in Advance!




















































































WeekCoverage AmountPres Cnt% of Pres
01/17/201315k833%
01/17/2013<15k938%
01/17/2013>30k28%
01/17/201330k313%
01/17/201320k28%
01/17/2013>15.01K<20k14%
01/17/2013>20.01K<30k28%
01/10/201315k829%
01/10/2013<15k1139%
01/10/2013>30k14%
01/10/201330k414%
01/10/2013>15.01K<20k27%
01/10/2013>20.01K<30k725%
Header 1Header 2
0 Replies