Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

MVP
MVP

Re: Sequential number instead of Dimension values

This?

Capture.PNG

Exp (using sortable aggr()):

=Aggr(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4,1),(ID,(sum({<Class={'A'}>}num(today())-num(Date)))))

divya_anand
Contributor II

Re: Sequential number instead of Dimension values

Hi Tresesco,

This is brilliant! Thank you so much!

Just 1 tiny thing - Is it possible to show only distinct values in here? I tried using distinct, but couldn't get it right.

divya_anand
Contributor II

Re: Sequential number instead of Dimension values

Or is it possible to number them 10,11,12 instead of 10, 10, 10?

MVP
MVP

Re: Sequential number instead of Dimension values

Putting Num() around like:

=Aggr(Num(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4)),(ID, (Num(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4)))))

Should have worked, but for some reason (I could not find out yet) few overlapped ranks are not getting sorted that way.

divya_anand
Contributor II

Re: Sequential number instead of Dimension values

Tresesco,

Ok, I will give it a try.

Thank you very much.

divya_anand
Contributor II

Re: Sequential number instead of Dimension values

Hi Tresesco,

This is exactly what I was looking for, it worked perfectly for me. Thank you so much!

=Aggr(Num(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4)),(ID, (Num(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4)))))