topic Re: concat function with a set expression in QlikView

concat function with a set expression

Anonymous — Mon, 06 Jul 2015 15:49:37 GMT

Hi,

My task is to display the name of the media which has a zero budget disregarding a user's selection in the field 'media'.

I tried this formula:

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

It doesn't work the way I need. It still takes into account a user's selection in the field 'media'.

How can I fix it?

Thank you in advance,

Larisa

MK_QSL — Mon, 06 Jul 2015 15:54:58 GMT

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

Anonymous — Mon, 06 Jul 2015 16:00:29 GMT

Thank you!