topic Re: How to group and present the data into pie chart in QlikView

How to group and present the data into pie chart

Thu, 24 Jan 2013 14:03:23 GMT

Dear Sir,

I would like to be able to group data in a column to create a pie chart.

The source table gets 2 columns only - PO and required_date (i.e. required delivery date)

Following has been inserted in the script to calaulate the balance days for delivery.

Num(Date(request_date ,'DD-MM-YYYY'))-Num(today(),'DD-MM-YYYY') as M_Req_Bal_Day,

I want to group the M_Req_Bal_Day into 3, and present into pie chart format.

- < 0 (i.e. late delivery)

- >0 and <7 (i.e. goods should be delivery in coming 7 days)

- > 7 (i.e. goods will be delivery next week)

I think it is quite simole for someone with more experience but i am new in qlikview so guys any help would be very appreciated!!!

Thanks

Re: How to group and present the data into pie chart

Thu, 24 Jan 2013 14:27:45 GMT

Hi,

If you are counting the POs that are delivered late, in the coming days or in the next week, try using these expressions in the pie chart.

1. count({<M_Req_Bal_Day)={'<0'}>}PO)

2. count({<M_Req_Bal_Day)={'>0<7'}>}PO)

3. count({<M_Req_Bal_Day)={'>0'}>}PO)

Hope it helps.

Regards,

-Khaled.

Re: How to group and present the data into pie chart

Thu, 24 Jan 2013 16:34:45 GMT

Dear Khaled.

Thanks for your advice. However, the pie chart was displayed in following.

In the Pie Chart dimension - M_Req_Bal_Day is used.

In the Expression, your suggestion is applied. However, the result is not in 3 groups.

= Count({<M_Req_Bal_Day={"<0"}>} PO)

= Count({<M_Req_Bal_Day={">0<7"}>} PO)

= Count({<M_Req_Bal_Day={">7"}>} PO)

Highly appreciately if any further advice can be provided. Thanks much.

Re: How to group and present the data into pie chart

Thu, 24 Jan 2013 17:45:27 GMT

You will need to add a few columns. The first you will use to calculate the number of days between today and the required date. The second will be an if statement to create buckets based on the range you specified.

Here is how it would work.

Re: How to group and present the data into pie chart

Thu, 24 Jan 2013 18:30:27 GMT

Hi,

Try removing the dimension from the Pie Chart. It would still give you the result and hopefully, meet your requirement.

Hope it helps.

Regards,

-Khaled.

Re: How to group and present the data into pie chart

Thu, 24 Jan 2013 21:15:12 GMT

Try this dimension:

if(Days_To_Ship<=0, 'Late',
if(Days_To_Ship

>7,'Next Week',
'Coming 7 Days'))

Thanks !!