Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
...
;
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)
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
...
;