Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Frequencies and Percentages

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

MVP
MVP

Re: Frequencies and Percentages

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

nagarjuna_kotha
Valued Contributor II

Re: Frequencies and Percentages

Can you share sample file ?

Community Browser