topic Re: Create a pie chart in QlikView

Create a pie chart

Tue, 02 Jun 2015 22:15:17 GMT

I have never worked with using pie charts before and I can't seem to find a lot of information about them. Can someone point me in the right direction on finding some information????

I want to create a pie chart that uses a field that contains a value for number of days purchased in advanced. The field is called Advance Ticketing. I have another field that contains number of tickets issued; call this Tickets Issued.

I want the pie chart to reflect the following:

0 - 6 days

7 - 13 days

14+ days

So each of these would have a percentage of how many tickets were issued for each category.

What I'm not sure of is how to set the dimension to reflect the three different categories I want to report on?????

Do I use the dimension limits in some way to set these categories up????

Re: Create a pie chart

swuehl — Tue, 02 Jun 2015 22:24:31 GMT

Create a calculated dimension:

=if( AdvancedPurchasedField < 7, dual( '0 - 6 days', 6),

if( AdvancedPurchasedField < 14, dual( '7 - 13 days', 13), dual('14+ days', 14)

)

and as expression:

=sum(TicketsIssuedField)

You can also enable relative option on expression tab.

Re: Create a pie chart

MarcoWedel — Tue, 02 Jun 2015 23:39:47 GMT

Hi,

another solution could be to precalculate the buckets (depending on your table size this might improve your application performance):

tabTickets:
LOAD RecNo() as ID,
    Floor(Rand()*21) as [Advance Ticketing],
    Ceil(Rand()*10) as [Tickets Issued]
AutoGenerate 100;

tabAdvTickClass: 
LOAD *, AutoNumberHash128(RangeMin, RangeMax) as %ClassID; 
LOAD RangeMin, Alt(Peek(RangeMin)-1, Dual('∞', 100000000000000)) as RangeMax 
Inline [ 
RangeMin
14 
7 
0 
]; 

tabIntMat: 
IntervalMatch ([Advance Ticketing]) 
LOAD RangeMin, RangeMax 
Resident tabAdvTickClass; 

Left Join (tabTickets) 
LOAD [Advance Ticketing], 
    Dual(RangeMin&' - '&RangeMax&' days', RangeMin) as [Advance Ticketing Class], 
    AutoNumberHash128(RangeMin, RangeMax) as %ClassID 
Resident tabIntMat; 

DROP Tables tabIntMat;

hope this helps

regards

Marco

Re: Create a pie chart

Wed, 03 Jun 2015 20:51:49 GMT

understand the calculated dimension but not sure about the expression.

I would want the percentage of each category to be divided by the total tickets issued.

for example:

let's say the total number of advanced for 0 - 6 has 20 tickets and the total issued altogether is 170 so 0 -6 would show 12%, 7-13 has 50 tickets so it would be 50/170 for 29%, etc.

so the expression would have to be the sum of the category / sum(ticketsissuedfield)

how would that expression look????

Re: Create a pie chart

swuehl — Wed, 03 Jun 2015 20:55:02 GMT

=sum(ticketsissuedfield) / sum(total ticketsissuedfield)

The TOTAL qualifier should do the magic of summing all tickets across dimensions.

Re: Create a pie chart

Wed, 03 Jun 2015 20:59:38 GMT

I get a 100% for each category if I do that

Re: Create a pie chart

swuehl — Wed, 03 Jun 2015 21:08:02 GMT

Does

=sum(ticketsissuedfield)

correctly return the ticket number for each bucket?

Re: Create a pie chart

Wed, 03 Jun 2015 21:13:24 GMT

if I do sum(ticketissuedfield) i get 20,300%, 26,900%, & 19,300%

Re: Create a pie chart

MarcoWedel — Wed, 03 Jun 2015 21:13:32 GMT

did you try setting the expression to "relative":

hope this helps

regards

Marco

Re: Create a pie chart

Wed, 03 Jun 2015 21:15:47 GMT

yes, that's what I was missing.

thanks

Re: Create a pie chart

MarcoWedel — Wed, 03 Jun 2015 21:34:32 GMT

glad it works

please close your thread if your question is answered.

thanks

regards

Marco