Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try replacing $(=NAV1.ProductCode) with $(=concat(distinct chr(39) & [NAV1.ProductCode] & chr(39), ',')
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?
thanks
please ignore this post.
behaviour was caused by somethin else.
thank you very much!