topic Re: Value differs from Straight to Pie Chart in QlikView

Value differs from Straight to Pie Chart

krishna20 — Thu, 26 Mar 2015 05:19:42 GMT

Hi Friends,

The value is differs from straight to Pie chart.But, I have used the expression is same in the both charts.what may be the problem is?why it is differing?

Regards

Krishna

Re: Value differs from Straight to Pie Chart

jonathandienst — Thu, 26 Mar 2015 05:29:31 GMT

Either the expressions differ, or the dimensions, or you have selected an option like Relative for one of these objects. Post a sample for more accurate help.

HTH

Jonathan

Re: Value differs from Straight to Pie Chart

krishna20 — Thu, 26 Mar 2015 05:57:30 GMT

Hi Jonathan,

Thank you for your suggestion. It works. But i need to show the values in the pie chart and Pivot(straight) for 100 %. The Percentage total i'm getting exceeds to 100. Please, find the sample app and suggest me on this.

Re: Value differs from Straight to Pie Chart

krishna20 — Thu, 26 Mar 2015 06:30:12 GMT

Hi Friends,

Any Suggestions?!!

Re: Value differs from Straight to Pie Chart

Thu, 26 Mar 2015 06:57:44 GMT

Your 0%'s aren't true zero percentages...

Re: Value differs from Straight to Pie Chart

Thu, 26 Mar 2015 06:59:30 GMT

Hi,

In scurity table TT_TREATY_CODE field is having the only 28% ratio.

Thats why, You can use in script this expression.

Re: Value differs from Straight to Pie Chart

krishna20 — Thu, 26 Mar 2015 08:11:15 GMT

Hi,

When i'm using Expression with Relative option the data is matching with the database but not with the straight or pivot table. Please ,anyone can help me out.