Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Just use Count(Value)

Highlighted
Creator II
Creator II

Hi,

Try this;

Count(distinct total <ID > Values)
Highlighted

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

Creator II
Creator II

H Sunny,

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

Highlighted
Master
Master

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

Highlighted
Master
Master

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

Highlighted

Count(Value) as a measure should resolve your problem