topic Re: embedded expressions in QlikView

embedded expressions

Anonymous — Mon, 06 Jul 2015 12:05:55 GMT

Hi,

My task is to select all existing values of the field Media regardless of a user's selection and then inside this set of values I should select only those media whose Budget >0 and count them those media.

The first step is to get all media regardless of a user's choice:

Expression1: {Media=}

The second step to get the media whose Budget >0:

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

Now I need to calculate expression 2 inside expression 1.

Intersection '*' doesn't work.

Could you please advise something?

Thank you in advacne,

Larisa

Re: embedded expressions

MK_QSL — Mon, 06 Jul 2015 12:12:23 GMT

SUM({<Media ={"=SUM({1}Budget)>0"}>}Budget)

Re: embedded expressions

MayilVahanan — Mon, 06 Jul 2015 12:13:30 GMT

Try like this

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

Re: embedded expressions

lironbaram — Mon, 06 Jul 2015 12:23:03 GMT

you can try this one

=count({<Media=>}aggr(if(sum({<Media=>}Budget)>0,only({<Media=>}Media)),Media))