Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ni_avoss
Creator
Creator

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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
ni_avoss
Creator
Creator
Author

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
Creator
Creator
Author

please ignore this post.

behaviour was caused by somethin else.

thank you very much!