topic Re: Splitting a pie chart into percent in QlikView

Splitting a pie chart into percent

Tue, 25 Aug 2015 16:14:43 GMT

Hi, I am having issues using pie charts.

The data I have is, I have a set of rooms.

I have a list of people who have access to each of these rooms.

I want to count how many rooms there are with less than 10 people with access to these rooms.

I want the pie chart to show what fraction of the rooms have less than 10 users with access.

I have tried:

=if(count(Distinct(aggr([Room], [User])))<=10, count(distinct([Room])))

this gives me the total count of the rooms rather than only those with 10 users or less.

I have been stuck on this for awhile. Any help is greatly appreciated.

Thank you.

Re: Splitting a pie chart into percent

maxgro — Tue, 25 Aug 2015 16:27:46 GMT

maybe a pie chart with 2 expression

sum(if(aggr(count(DISTINCT User), Room)>10,1))

sum(if(aggr(count(DISTINCT User), Room)<=10,1))

Re: Splitting a pie chart into percent

Anonymous — Tue, 25 Aug 2015 16:28:47 GMT

Hi,

Maybe use:

=if(aggr(sum(DISTINCT [User]),[Room]))<=10, count(distinct([Room])))

Re: Splitting a pie chart into percent

Qrishna — Tue, 25 Aug 2015 16:29:15 GMT

provide some sample data.

Re: Splitting a pie chart into percent

Tue, 25 Aug 2015 16:54:30 GMT

I tried this. It doesn't recognize summing the numbers together. It says its a bad expression if you put 'sum' at the beginning of everything else you put.

Thanks for the suggestion anyways.

Re: Splitting a pie chart into percent

Tue, 25 Aug 2015 16:55:11 GMT

no dice, still gives the total number of rooms rather than just the number with 10 users or less.

Re: Splitting a pie chart into percent

Anonymous — Tue, 25 Aug 2015 17:02:42 GMT

Please try:

=if(aggr(rank(-sum(DISTINCT [User])),[Room]))<=10, count(distinct([Room])))

Re: Splitting a pie chart into percent

maxgro — Tue, 25 Aug 2015 17:10:00 GMT

PFA