Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MoxieMeister
Contributor II
Contributor II

Qlik Cycle

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?

 FirstFirstSecondSecond

1 Solution

Accepted Solutions
Arthur_Fong
Partner
Partner

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

View solution in original post

1 Reply
Arthur_Fong
Partner
Partner

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

View solution in original post