topic Help needed in Pie chart in QlikView

Help needed in Pie chart

Tue, 29 Mar 2011 13:08:24 GMT

Hi all,

I have one order table, in that they have different parts and order detils.

for example all of them ordered Part A as 11 times. i.e.,total count of Part A.

they ordered B as 20 times irrespective of customers and C ordered as 5 times and D as 3 times.

i would like to show in pie chart as 0-5 times,6-10 times,>10 times as come in dimensions, and the percentage in expression.

if i show the above example in pie chart, the values are 0-5 times as 50%, 6-10 times as 25% and >10 as 25%

could anyone help me how to show this one..

Help needed in Pie chart

Tue, 29 Mar 2011 13:10:55 GMT

Hi, have you tried the class function ?

Help needed in Pie chart

Tue, 29 Mar 2011 13:12:56 GMT

Would an easier solution be to use the intervalmatch function and populate another field in your table?

Re. :Help needed in Pie chart

Tue, 29 Mar 2011 13:14:44 GMT

Hello,

Did you try to use a table like :

OrderTime:

load * inline [

Id, Min,Max, Desc

1, 0 , 5 , 0-5 Time

2, 6 , 10 , 6 - 10 Time

....

]

Then in the load of your order table using the intervalmatch function.

You will be then able to display the Desc field as dimension and do the proper calculation for the %

Hope that helps.

Philippe

Re. :Help needed in Pie chart

Tue, 29 Mar 2011 13:44:37 GMT

I have the table like Customer,Type,OrderNo,Date,Part code...

how can i group that things and how can analysis like this customer ordered this many times this part and i need to show the number of parts in 0-5 times orders, etc., by customerwise,countrywise,monthwise,etc...

could anyone help me.....

thanks in advance

Re. :Help needed in Pie chart

Tue, 29 Mar 2011 14:29:01 GMT

Hi Gopinathan,

It sounds like you want to use Philippe's methdology of the interval match in the script.

Typically, an interval match is achieved by making a load statement with your bucket sizes, as Philippe has shown.

Then you reload the start and end fieldnames and in front of the load statement you put "intervalmatch(Fieldname you want to match). Philippe's inline load is perfect. The BucketKey created below is in order to rid yourself of the synthetic key.

E.g.

Buckets:

LOAD *,

StartValue & EndValue as BucketKey;

LOAD

StartValue,

EndValue,

DisplayName;

IntervalMatch_Temp:

intervalmatch(Fieldname that you want to slot into the above buckets)

StartValue,

EndValue

Resident Buckets;

IntervalMatch:

StartValue & EndValue as BucketKey,

(Fieldname that you want to slot into the above buckets)

Resident IntervalMatch_Temp;

drop table IntervalMatch_Temp;

The class function presupposes that your bucket sizes are fixed in size. Even though you can allow your end-users to select the bucketsize itself with a variable, all buckets will be same size.

If you need more help, please attach a sample QVW with sample data. The intervalmatch is not complicated.

Re. :Help needed in Pie chart

Tue, 29 Mar 2011 14:31:10 GMT

Sorry. Forgot. The " by customerwise,countrywise,monthwise,etc.." would be achieved in the front-end by putting in cyclical dimension.