topic Re: 'where' statement in a variable in QlikView

'where' statement in a variable

Wed, 25 Nov 2020 16:16:04 GMT

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?

swuehl — Fri, 17 Jun 2016 09:11:01 GMT

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

varshavig12 — Fri, 17 Jun 2016 09:13:54 GMT

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

Fri, 17 Jun 2016 09:24:21 GMT

Thanks for the quick respons. Comma makes the difference .