Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Resetting rank

hi,

I required the desired rank column in the given excel below.

At the month end date and max of the last month I need numbering in the descending order .

Please look into the excel for better understanding.

Thanks

1 Solution

Accepted Solutions
Highlighted

Re: Resetting rank

Perhaps this?


Table:
LOAD Date,
Category,
Product,
Flag
FROM
[Comm1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Left Join
Load *, If(Flag<>0, AutoNumber(RecNo(), Product), '') as Dense_Rank Resident Table Order By Date desc;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

5 Replies
Highlighted

Re: Resetting rank

Perhaps simply like

Table:
Load * From <Excel>;

Left Join(Table)

Load Date, Category, Flag, If(Flag<>0, RowNo()) as Desired Rank Resident Table Order By Date asc;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

Re: Resetting rank

hi Anil,

 

Thanks for quick reply if there are two or more products then the number is not correct

Highlighted

Re: Resetting rank

You meant as follows?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

Re: Resetting rank

hi anil,

Please find the updated excel.

Highlighted

Re: Resetting rank

Perhaps this?


Table:
LOAD Date,
Category,
Product,
Flag
FROM
[Comm1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Left Join
Load *, If(Flag<>0, AutoNumber(RecNo(), Product), '') as Dense_Rank Resident Table Order By Date desc;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post