If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi Folks, i got the following issue, my data-environment does look like:
on the UI within the Expression - Editor i am using this Expression:
Aggr(concat(distinct Values, ' , '),ID) then i have the following structure:
1, (2, 4, 5)
2, (4, 6)
the above Expression does work great. my Question is:
how can i show the following strukture:
1, 3 (because id =1 has total3 values)
2, 2 (because id = 2 has total 2 value)
i was trying to solve it by using the following Expression: aggr(concat (Count(Values), ' , '), ID) but i did not achieve the expected result.
Does anybody have any idea how to solve the above issue in script-area and on UI (Expression editor)?
Thanks a lot in advance