topic Re: Multiple Fields count in pie chart in QlikView

Multiple Fields count in pie chart

Tue, 10 Nov 2015 02:58:17 GMT

Hi Team,

I have a dimension name and 4 other measures which has counts of low,medium,high risks

Can you please let me know the way to achieve this in pie chart as it doesn't allow more than 1 measure.

Thanks,

tresB — Tue, 10 Nov 2015 05:26:28 GMT

If you want the pie on expressions, remove the dimension. Or, you want pies on dimension values, you might opt for trellis (dimension tab).

sasikanth — Tue, 10 Nov 2015 06:01:41 GMT

HI,

Another way is , Create one calculated Dimension at script Level based on this Low , medium and High if Possible

Then use this one along with your original Dimension as Drill down option

Exp is same Count()

nagarjuna_kotha — Tue, 10 Nov 2015 06:06:47 GMT

Hi S V ,

Pie Chart allows more thn eone Expression but it gives only first Expression Values only.

Can u share sample files?

Regards,

Nagarjuna

Anonymous — Tue, 10 Nov 2015 06:09:38 GMT

Also, you can create 3 dimension fields on the base of flag at script level..

IF(Flag='high', Dim) as HighDim,

IF(Flag='Low', Dim) as LowDim....

Then you can create cyclic group of those dimension with the same expression