Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

ni_avoss
New Contributor III

select several values in set expression by variable

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

1 Solution

Accepted Solutions

Re: select several values in set expression by variable

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


talk is cheap, supply exceeds demand
3 Replies

Re: select several values in set expression by variable

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


talk is cheap, supply exceeds demand
ni_avoss
New Contributor III

Re: select several values in set expression by variable

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
New Contributor III

Re: select several values in set expression by variable

please ignore this post.

behaviour was caused by somethin else.

thank you very much!

Community Browser