Discussion board where members can get started with Qlik Sense.
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
Just use Count(Value)
Count(distinct total <ID > Values)
That seems very complicated if ID is the only dimension....
Yea you are right. I thought there would be another dimensions too.
thanks a lot your time and Suggestion, i know this Expression, but i would like to know, how to solve this issue in script-area or UI
Thanks a lot
Hi Sunny, thanks a lot for your time and Suggestion.
if you have any idea how to solve this issue, please let me know
Count(Value) as a measure should resolve your problem