topic how to exclude records from chart expression in QlikView

how to exclude records from chart expression

maart — Mon, 26 Oct 2009 01:15:53 GMT

hi,

I have a table with 3 fields regarding expenses: date, category and amount. There are 6 categories of expenses.

In a chart having the date as dimension, I would like to set the expression as a sum of the amounts but excluding one or the category (salary expenses) and including just the other 5.

Thanks

how to exclude records from chart expression

mongolu — Mon, 26 Oct 2009 02:07:17 GMT

Salve.
I see you are a fellow romanian.

You could try the if sentence:
SUM( IF(Category<>'Salary expenses',Amount) )

or the Set Analysis:
SUM( {$< Category -= {"Salary expenses"} >} Amount ).

how to exclude records from chart expression

maart — Mon, 26 Oct 2009 02:21:03 GMT

Salut Mihai,

I am glad that you replied me.

Your answer solved my issue. I used your first suggestion. As for the second, didn't worked the same, don't know why. Not familiar with Set Analysis.

Many thanks,

Marius