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
Creator
Creator

Dimension for categories

I have table:

ROW              ID

1                       5

2                       6

3                       5

3                       6

4                       5

4                       6

4                       6

4                       6

5                       5

5                       6

5                       8

I need count the number of ID.

The final table should be:

ROW              ID

1                       1 - >(5)

2                       1 - >(6)

3                       2 - >(5,6)

4                       2 - >(5,6)

5                       3 - >(5,6,8)

Could you help me, how can I do it in script ?

Thank you. 

 

1 Reply
Highlighted
Partner
Partner

Load

Count(distinct(ID) as ID,

Row

Resident Table

Group by Row;