Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pie Charts & Negative Data After Applying Filter

I have a pie chart which shows total spend by customer. I am able to apply filters in the dahsboard by date so for example March to July spend. If a customer placed business in February, but then had a refund in March, the March spend for that customer is a negative value (which is ok). However when I filter the data to show March to July spend only my pie chart displays an error message which says "positive and negative values in chart" and displays no chart. I fully understand why it is doing this, but I want my data in a Pie Chart, and I want to be able to filter by date. Is there any way around this? Is there a way to get the pie chart to ignore negative values when filtering for example? Thanks. Jenny.

1 Solution

Accepted Solutions
danielrozental
Honored Contributor II

Pie Charts & Negative Data After Applying Filter

Sure, try something like if(sum(sales)>=0, sum(sales)) to filter negative values.

2 Replies
danielrozental
Honored Contributor II

Pie Charts & Negative Data After Applying Filter

Sure, try something like if(sum(sales)>=0, sum(sales)) to filter negative values.

Not applicable

Pie Charts & Negative Data After Applying Filter

So simple! Thats super thanks

Community Browser