Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Sameer9585
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
Anil_Babu_Samineni

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
Anil_Babu_Samineni

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)
Sameer9585
Creator II
Creator II
Author

hi Anil,

 

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

Anil_Babu_Samineni

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)
Sameer9585
Creator II
Creator II
Author

hi anil,

Please find the updated excel.

Anil_Babu_Samineni

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