topic Re: Single Column Pie-Chart in QlikView

Single Column Pie-Chart

Thu, 02 Apr 2015 08:16:53 GMT

How would I go about Creating a pie-chart for a single column set of data.. I have two columns, one with items(Item), and another with values(price_changes) which are 0, or positive or negative. I need to create a pie chart with the sum of price changes that are 0, that are greater than 0 and price changes that are lesser than 0..

I am trying with these dimensions

=count({<Price_Changes={'=0'}>}Price_Changes)

=count({<Price_Changes={'>0'}>}Price_Changes)

=count({<Price_Changes={'<0'}>}Price_Changes)

and my Expression is Count(Item)

I keep getting an error.. Can anyone point me in the right direction?

I'm an absolute noob with qV.. Kindly be gentle..

Re: Single Column Pie-Chart

Thu, 02 Apr 2015 09:28:43 GMT

Hi,

You can use if condition.

=If(Price_Changes=0,Price_Changes)

=If(Price_Changes>0,Price_Changes)

=If(Price_Changes<0,Price_Changes)

Re: Single Column Pie-Chart

stigchel — Thu, 02 Apr 2015 09:47:18 GMT

You're expressions in the dimension, whether or not correct, results in the values of Price_Changes, no matter what the if condition is. In the calculated dimension you want to group the Price Change values, something like:

=if(Price_Changes=0,'Zero',if(Price_Changes>0,'Positive',if(Price_Changes<0,'Negative')))

This will create three grouped values of price change named Zero,Positive and Negative

Re: Single Column Pie-Chart

Thu, 02 Apr 2015 09:57:42 GMT

Hi,

You can use below code. I think it is helpful to you.

In dimension,

=if(Price_Changes=0,Price_Changes,if(Price_Changes>0,Price_Changes,if(Price_Changes<0,Price_Changes)))

In expression,

Sum(Item) or Count(Item)

Re: Single Column Pie-Chart

Thu, 02 Apr 2015 17:31:50 GMT

Thank you for explaining the logic behind it. I understand now. Thanks a ton!!

Re: Single Column Pie-Chart

Thu, 02 Apr 2015 17:36:05 GMT

Thank you, your solution did give me a pie chart, but it listed the no. of items with respect to their price changes. I mean the actual value..

=if(Price_Changes=0,'Zero',if(Price_Changes>0,'Positive',if(Price_Changes<0,'Negative')))

^ This worked perfectly for me though. I still want to thank you for taking the time to help me. I appreciate it a lot.