topic Re: Filter dimensions in pie chart in QlikView

Filter dimensions in pie chart

anuradhaa — Tue, 21 Oct 2014 09:30:25 GMT

Hi,

I have country as a dimension. and i have created sales by country pie chart.

But now i want to get sales by specific countries,

say "USA","UK","FRANCE","JAPAN".

Please tell me how to do that.

Thank in advance

Re: Filter dimensions in pie chart

Gysbert_Wassenaar — Tue, 21 Oct 2014 09:35:31 GMT

1. Add a listbox (or multibox) with the country field and select the countries you want in the listbox (or multibox).

2. Change the expression in the pie chart. For example change sum(Sales) to sum({<country={'USA','UK','FRANCE','JAPAN'}>}Sales) to make the expression filter the countries to those listed.

Re: Filter dimensions in pie chart

rustyfishbones — Tue, 21 Oct 2014 09:35:46 GMT

Use Country as Your dimension and change the Expression to

SUM({<Country = {'USA','UK','FRANCE','JAPAN'}>}Sales)

Re: Filter dimensions in pie chart

Tue, 21 Oct 2014 11:05:10 GMT

Choose the countries what you want in the chart and writhe the expression as SUM({<Country = {'USA','UK','FRANCE','JAPAN'}>}Sales)