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

Frequencies and Percentages

Hi all,

I need some help with a pivot table that has frequencies along with associated percentages.

So I used this expression as a dimension in the pivot table for the frequencies:

aggr(count(DiseaseID), BenKey)

Then need to use something like this to calculate the percentages:

count( distinct if(StatusID = 2, BenKey )) / count(distinct total <........> if(StatusID=2,BenKey))

But I need to insert the dimension above in the <...> to get the correct totals per frequency but it doesn't work if you put that expression in.

What can i do??

Thanks

James

3 Replies
MK_QSL
MVP
MVP

You can provide sample data first along with the expected output !

tresesco
MVP
MVP

If you have multiple dimensions in the chart, you have to rather use that dimensions which are just prior to BenKey in <..>

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Can you share sample file ?