Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
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,
Go to Solution.
Try replacing $(=NAV1.ProductCode) with $(=concat(distinct chr(39) & [NAV1.ProductCode] & chr(39), ',')
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?
please ignore this post.
behaviour was caused by somethin else.
thank you very much!