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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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