Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

maart
New Contributor

how to exclude records from chart expression

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

Tags (1)
1 Solution

Accepted Solutions
mongolu
Contributor

how to exclude records from chart expression

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 ).

2 Replies
mongolu
Contributor

how to exclude records from chart expression

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 ).

maart
New Contributor

how to exclude records from chart expression

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

Community Browser