Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

using a calculated expression inside a set expression

Hi,

I need to define only those media whose budget >0 inside a set expression.

I might be like this:

{<Media={="expression"}>}

I tried this expression:

{<Media={="aggr(sum([Budget])>0, Media)"}>}


But it doesn't work.


Can you help me?


Thank you in advance,


Larisa

1 Solution

Accepted Solutions
sinanozdemir
Specialist III
Specialist III

Try this:

{<Media = {"=aggr(sum([Budget]), Media)>0"}>}

Hope this helps.

View solution in original post

3 Replies
sinanozdemir
Specialist III
Specialist III

Try this:

{<Media = {"=aggr(sum([Budget]), Media)>0"}>}

Hope this helps.

sunny_talwar

Slight correction:

{<Media = {"=Aggr(Sum([Budget]), Media) > 0"}>}

sunny_talwar

This might aslo work for you:

Sum/Count/Min/Max(If(Aggr(Sum([Budget]), Media) > 0, Measure))