Qlik Cycle

[MoxieMeister]

Hi guys, I need to number the teams for each city, for example for Manchester there are only 2 teams and as a result numbering will be 1, 2. For London 1 to 6. How I can do this?

 FirstSecond

[Arthur_Fong · Accepted solution]

Try this at the load script:

Team:
Load *,AutoNumber(Team,City) as Number;
Load * inline [
Team,City
Manchester United,Manchester
Manchester City,Manchester
Chelsea,London
Arsenal,London
Fulham,London
Tottenham,London
West Ham,London
West Bromwich,London
];

Instead of inline, load from your source and add in this preceeding load:

Load *,AutoNumber(Team,City) as Number;

Qvf attached for reference.

Thanks and regards,

Arthur Fong