I designed PI chart but I want to positive values as positive and negative values as negative.
BUt any single row having negative value is shows error Positive and negative values in a chart.
But i want to display both values as it is in chart.Administrator
Considering that your have below expression
Instead of above expression, change as below
Untick values on datapoint
Now Create 2nd Expression
Tick Values on datapoint...
Change expression as
If(Sum(Sales)<0, Num(Fabs(Sum(Sales)), '-#,###'), Num(Sum(Sales), '#,###')
It will show you both positive and negative values in pie chart
Think of the problem visually, If your data has values 3,4,5, then you can see how the pie chart will show the three different segments with sizes proportional to the value.
If the data has values 3, -4, 5, how would you display a segment that is -4 in relation to the other two positive values? Hence the error. You cannot mix positive and negative values in a pie chart.
If all values in the pie chart are negative then QlikView will display the chart. So values of -3, -4, -5 will work in a pie chart.
FABS() will convert the data to absolute values to 3, -4, 5 will be changed to 3, 4, 5 but this may not be correct.
If you want to see both positive and negative values, use a bar chart not a pie chart !