Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use two set analysis in one expression ?

Hi guys,

How to use two set analysis in one expression ?

Exp.PNG

Please help.

Thanks.

3 Replies
Mark_Little
Luminary
Luminary

Hi,

What exactly you trying to achieve?

Depending what you are trying to show it maybe possible.

I would advise first try the & symbol between the expressions maybe &'   '& to add some spaces.

Mark

Anonymous
Not applicable
Author

if you just want 1 sum instead of two and both expressions are identical (besdie actual, Budget)

you need to Change

Indicator_Type={'ACTUALS','BUDGET'}

then you can get rid of your second sum

Not applicable
Author

exp1.PNGexp2.PNG

Thanks for your reply.

After adding & between the expressions - 0 is being added before the value. How can i exclude that 0 ?