App Development

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for
Did you mean:
Contributor III

How to create ranged table

I have a table with two columns, on of ID and the other of numbers.

 ID NUM 8997765 0 8899654 1 8889777 2 8888554 9 8889776 50 8877954 100 8885532 105

How can  i turn it to this?

 COUNT(ID) NUM (fixed string) 3 0-9 2 9-99 2 100+
Labels (1)
• General Question

1 Solution

Accepted Solutions
Master

Hi

May be with a calculated dimension based on NUM :

=if(NUM<9,dual('0-9',1),
if(NUM<99,dual('10-99',2),
if(NUM>=100,dual('100+',3))))

i used if statement aned dual function to make order by 0-9 10-99 and 100+ easier

mesure is count(ID)

Master

Hi

May be with a calculated dimension based on NUM :

=if(NUM<9,dual('0-9',1),
if(NUM<99,dual('10-99',2),
if(NUM>=100,dual('100+',3))))

i used if statement aned dual function to make order by 0-9 10-99 and 100+ easier

mesure is count(ID)

Tags
Community Browser