App Development

Discuss and learn more about Qlik Sense app development and usage.

Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More

Who Me Too'd this topic

Stas_vd_Braber
Partner - Contributor II
Partner - Contributor II

Qlik Sense - Outer Set Expressions Error

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?

clownbassie_0-1673620019050.png

 

 

 

 

Labels (1)
  • SaaS

Who Me Too'd this topic