topic Re: Frequencies and Percentages in QlikView

Frequencies and Percentages

Tue, 06 Oct 2015 11:55:40 GMT

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

MK_QSL — Tue, 06 Oct 2015 12:25:02 GMT

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

tresB — Tue, 06 Oct 2015 12:28:25 GMT

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

nagarjuna_kotha — Tue, 06 Oct 2015 12:31:44 GMT

Can you share sample file ?