Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Assign Different Alias for different Tables

I have 3 tables: A, B, and C.   Each has a field called City.  I wanted to assign City from A as A.City, B as B.City and C as C.City;

I tried the following code, but the Qlik Aliased all cities as A.City.   Is there a way to limit the range of Alias?

[table A]:

Alias [City] as A.City;

SQL Select * from A;

[table B]:

Alias [City] as B.City;

SQL Select * from B;

[table C]:

Alias [City] as C.City;

SQL Select * from C;

Labels (1)
1 Reply

You can remove Alias everywhere it will work (Ex [City] as C.City)

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)