topic Assign order number based on another dimension column value in App Development

Assign order number based on another dimension column value

theo_pf — Tue, 19 Oct 2021 14:39:19 GMT

Hi all,

Given a table as the one on the screenshot below:

I would love to create a new column on the right side giving me the order of each row based on its ID and its antiquity as well. In other words, my desired output should look as follows:

I know this is doable in Qlik View by combining aggr() and rowno() functions. Nevertheless I've tried to replicate this method in Qlik Sense but all my attempts had been unsuccessful so far. How should I do to get this outcome?

Thanks a lot in advance.

Re: Assign order number based on another dimension column value

Saravanan_Desingh — Tue, 19 Oct 2021 14:51:00 GMT

Try this,

tab1: LOAD *, AutoNumber(RowNo(),ID) As ORDER INLINE [ ID, DATE, STATUS 1, 1/2/2020, Done 1, 1/3/2020, Done 1, 1/5/2020, Done 1, 1/6/2020, Done 1, 1/8/2020, Pending 2, 1/4/2020, Done 2, 1/5/2020, Done 3, 1/3/2020, Done 3, 1/4/2020, Done 3, 1/7/2020, Pending ];

Re: Assign order number based on another dimension column value

theo_pf — Tue, 19 Oct 2021 15:00:31 GMT

Sorry, I missed to specify I should use chart functions.