Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using this expression that works:
Sum({<[Material Number (Product)]={
'xyz'
},
[CalendarYear]={"=CalendarYear"} //$(=Max(CalendarYear)-1)
>}Quantity)
-
//previous year
Sum({<[Material Number (Product)]={
'xyz'
},
CalendarYear={"$(=Max(CalendarYear)-1)"} //$(=Max(CalendarYear)-1)
>}Quantity)
)
/
//previous year
Sum({<[Material Number (Product)]={
'xyz'
},
CalendarYear={"$(=Max(CalendarYear)-1)"} //$(=Max(CalendarYear)-1)
>}Quantity)
But I would like to filter [Material Number (Product)]={'xyz'} just once, and not all the time I apply a formula.
Is there any way?
something like:
if({<[Material Number (Product)]={'xyz'}>})...
???
The newer releases are supporting the combination of inner and outer set statements. Therefore you may try something like:
{<[Material Number (Product)]={'xyz'}
(sum(Quantity) - sum({< Year = {"$(=max(Year))"}>} Quantity)) /
sum({< Year = {"$(=max(Year))"}>} Quantity)
Hi Adriano,
Which Version of Qlik Sense are you using ? In the newer versions ie versions after 2021 i think, this is possible.
{<Material={"xyz"}>}
(Sum({<YTD expression>} Sales) - Sum({<PYTD Expression>} Sales))/
Sum({<PYTD Expression>} Sales)
The set for Material will apply on all the 3 sum expressions. Check the following link for more details :
Regards,
Rohan.
The newer releases are supporting the combination of inner and outer set statements. Therefore you may try something like:
{<[Material Number (Product)]={'xyz'}
(sum(Quantity) - sum({< Year = {"$(=max(Year))"}>} Quantity)) /
sum({< Year = {"$(=max(Year))"}>} Quantity)
Hi Adriano,
Which Version of Qlik Sense are you using ? In the newer versions ie versions after 2021 i think, this is possible.
{<Material={"xyz"}>}
(Sum({<YTD expression>} Sales) - Sum({<PYTD Expression>} Sales))/
Sum({<PYTD Expression>} Sales)
The set for Material will apply on all the 3 sum expressions. Check the following link for more details :
Regards,
Rohan.
qlick server version 14.129.21 parth 14 - May 2023