topic How to filter the data in charts in QlikView

How to filter the data in charts

Tue, 09 Nov 2010 08:12:45 GMT

hi,

i hv fields period with values jan 2004,feb.,...upto dec 2004

i hv chart to display the sum of sales when i click the field and i need the filter criteria to display feb and mar 2004 data alone.

thanks in advance

How to filter the data in charts

Tue, 09 Nov 2010 08:44:43 GMT

HI,

use Set Analysis in your chart expression similar to this:

sum ( { $ <period= {'feb 2004', 'mar 2004'}> } sales)

Regards Roland

How to filter the data in charts

Tue, 09 Nov 2010 10:21:22 GMT

Hi,

You can try as well to put one List box with year and another with month to filter the Date of your chart (you are fixing the dimension month/year). You can define as well the intervals in the list box that you want to filter your data. After that in your chart you only have to do a sum(sales).

Regards,

Joao