topic Re: Pie chart issue in QlikView

Pie chart issue

Srinivas — Tue, 10 Feb 2015 09:18:53 GMT

Hi All,

Pie chart normally show the relation between one dimension and one expression,but here my question is create one pie chart based on one dimension and three expressions,

If we select any particular region then that pie should show three parts (means here have three expressions )...

Regards,

Munna

Re: Pie chart issue

Tue, 10 Feb 2015 09:30:32 GMT

Hi,

Please see the attachment.

Thanks

Re: Pie chart issue

Srinivas — Tue, 10 Feb 2015 10:05:13 GMT

Thanks Sovan Naskar,

It's looking very nice but here I have one more query we want to show percentage values for each region wise expressions values. Can you help on this.

Advance Thanks,

Munna

Re: Pie chart issue

Tue, 10 Feb 2015 10:18:37 GMT

Hi ,

Please have a look this one.

Re: Pie chart issue

avinashelite — Tue, 10 Feb 2015 10:23:19 GMT

Hi Munna,

Use a IF condition and start clubbing all the expression, that will do and for the % use the num() function

Re: Pie chart issue

Srinivas — Tue, 10 Feb 2015 10:33:39 GMT

HI Avinash,

can you send me sample code, how can I approach &write if condition, that would be more helpful Aviansh.

Regards,

Munna

Re: Pie chart issue

Srinivas — Tue, 10 Feb 2015 16:01:43 GMT

Thanks Sovan, It's working fine

Re: Pie chart issue

Srinivas — Wed, 11 Feb 2015 05:01:03 GMT

Hi Sovan,

It's working fine but small issue , I hope this issue happen due to version problem, but we want to see only particular percentage only but this will shows all percentages at the same time see below screen

in above screen i don't want to see yellow marked values.

When I have checked version 11.00.112820.0.SR8 i didn't see this type. that showed only one division for value but here shows all values.

could you please help me.

Advance Thanks,

Munna

Re: Pie chart issue

Wed, 11 Feb 2015 06:21:03 GMT

Please uncheck Values on Data points on expression Tab and check Show numbers in Legends on the presentation tab.

Please let me know is it ok with you.

Thanks

Re: Pie chart issue

Srinivas — Wed, 11 Feb 2015 09:42:22 GMT

Hi Sovan,

sorry for irritating but i need some help from you.i tried Show numbers in Legends in this case initially bit confusion if we select any region then it's working fine.see below image

Above screen shows one , two and three values for each division,This application i opened Version 11.00.11282.0 SR1(My client using this version only ).. And same application i opened version 11.20.12577.0 SR8 here shows as per below screen shot way this is perfect-one.

we want show second(above) screen shot way.

Advance Thanks,

Munna