topic Re: select several values in set expression by variable in QlikView

select several values in set expression by variable

ni_avoss — Thu, 25 Jul 2013 16:07:43 GMT

Hi all,

to make i.e. products comparable, I created several tables using QUALIFY and then replacing the values with variables.

I guess an example explains it the best:

=sum({ProductCode={$(=NAV1.ProductCode)}>}$(=ValueField))

where NAV1.ProductCode is the result of one navigation out of a few...

well, this works fine so far if I select a single value, but I would also like to select multiples (which now is not possible ("No data to display")

Does anyone have an idea on how to achieve this?

Thanks and all the best,

Alex

Gysbert_Wassenaar — Thu, 25 Jul 2013 16:09:57 GMT

Try replacing $(=NAV1.ProductCode) with $(=concat(distinct chr(39) & [NAV1.ProductCode] & chr(39), ',')

ni_avoss — Thu, 25 Jul 2013 16:41:30 GMT

thanks, now its possible to select more than one.

but strangely it does not just adding those select, it seems like the values getting multiplied by x.

I.e. prod 1 got like 7k revenue, prod 2 gor 6k. If i select both they got 34 ?!?!

got an idea on this?

thanks

ni_avoss — Thu, 25 Jul 2013 17:06:57 GMT

please ignore this post.

behaviour was caused by somethin else.

thank you very much!