Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

Aggr concat with count

Hi Folks, i got the following issue, my data-environment does look like:

ID, Values,

1, 2

1, 4

1, 5

2, 4

2, 6

on the UI within the Expression - Editor  i am using this Expression:

Aggr(concat(distinct Values, ' , '),ID)  then i have the following structure:

ID, Value

1,  (2, 4, 5)

2, (4, 6)

the above Expression does work great. my Question is:

how can i show the following strukture:

ID, Value

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

Beck

 

 

Labels (1)
7 Replies
sunny_talwar

Just use Count(Value)

mfarsln
Creator II
Creator II

Hi,

Try this;

Count(distinct total <ID > Values)
sunny_talwar

That seems very complicated if ID is the only dimension....

mfarsln
Creator II
Creator II

H Sunny,

Yea you are right. I thought there would be another dimensions too.

beck_bakytbek
Master
Master
Author

Hi Mfarsin,

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

beck_bakytbek
Master
Master
Author

Hi Sunny, thanks a lot for your time and Suggestion.

 

if you have any idea how to solve this issue, please let me know

Thanks a lot

sunny_talwar

Count(Value) as a measure should resolve your problem