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: 
sabmaldun
Contributor II
Contributor II

Problem with autonumber Rank creation

Hey,

I want to create ranks for 3 KPI'S

I use autonumber for creating the ranks for each kpi. However if I join them back to the table together the rank from the 2. kpi is the same as the one from the 1. KPI.

Anyone knows why? or how to solve it?

Here is the Rankcreation:

KPI1Calc:
load Region,Brand,Year,Month,KPI1,DealerID,
if (KPI1 >0,AutoNumber(DealerID,Year&Month&Brand&Region),0) as RankKPI1
Resident FactTable
Order by Region,Brand,Year,Month,KPI1 desc;

Thank you

1 Reply
Sue_Macaluso
Community Manager
Community Manager

Is this for QlikView or Sense? I would like to move this into the correct product forum.
Sue Macaluso