topic using a calculated expression inside a set expression in QlikView

using a calculated expression inside a set expression

Anonymous — Mon, 06 Jul 2015 10:43:09 GMT

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

sinanozdemir — Mon, 06 Jul 2015 10:48:14 GMT

Try this:

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

Hope this helps.

sunny_talwar — Mon, 06 Jul 2015 10:50:12 GMT

Slight correction:

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

sunny_talwar — Mon, 06 Jul 2015 10:53:49 GMT

This might aslo work for you:

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