Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

'where' statement in a variable

Hello Community,

I try to make a variable but one of the "where" doesn't work.

Case:

tabel [year]  contains 2015 and 2016

tabel [type]  contains 'D' (deliver) and 'R' (receive)

tabel [amount] contains lines with # items.

In a variable i want to calculate the amount of [type] in a [year]

this is what i use:

Sum({<[type]={'D','d'}>}{<[year]={'2016'}>}[amount])

as result i see the total amount in 2016 but not the amount of deliver in 2016 (the result is the amount of deliver + receive in 2016).

how can i fix this?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Sum({<[type]={'D','d'}, [year]={'2016'}>}  [amount])

View solution in original post

3 Replies
swuehl
MVP
MVP

Sum({<[type]={'D','d'}, [year]={'2016'}>}  [amount])

View solution in original post

varshavig12
Specialist
Specialist

Sum({<[type]={'D','d'} , [year]={'2016'}>}[amount])

Not applicable
Author

Thanks for the quick respons. Comma makes the difference .