Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discuss and learn more about Qlik Sense app development and usage.
Hi all,
I encounter an irregularity when using the outer set expressions in Qlik Sense SaaS. I created a master measure (Gross sales). This master measure contains the following expression:
Sum({<[Sales/retour]*={'Sales'}>} Verkoop_Real)
+
Sum(Totaalkorting_Incl)
After this, I created a new measure which uses the master measure with an outer set expression. The filter in the outer set expression is on a year field where the value does not exists in the datamodel. In my logic, the result should be 0.
{<Jaar={2020}>} [Bruto omzet]
Nevertheless, the result is displayed as show below in the image. Can anyone explain why this happens or provide me with a solution?