topic conditions in set analysis in QlikView

conditions in set analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I am totally new to Qlik in general and I have a problem :

I want to sum all the products for the current year but i don't know how to formulate it.

sum({<{ "$(Yearname(Month))" } = { "$(=Yearname((Today(),0)))" }>} Products)

This is the formula I try to use but it does not work and I am not experienced enough to understand where is the problem.

Thanks for your help

Re: conditions in set analysis

Anonymous — Wed, 20 Jul 2016 15:57:07 GMT

HI,

FIrst you need to have a filed consisting the Year for the data.

Then You can write the expression ass

sum({<Year={$(=year(today()))}>}Products)

Re: conditions in set analysis

Gysbert_Wassenaar — Wed, 20 Jul 2016 15:59:12 GMT

If you have a year field use sum({<YearFieldHere = {'$(=Year(ToDay()))'} >} Products). If you don't have a year field create one in the script from your date field.

LOAD

Date,

Product,

Year(Date) as YearFieldHere

FROM

...

;