Qlik Community

New to Qlik Sense

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove synthetic keys

Hi,

I have historical data for many different things. Obviously each of these is headed with the year/quarter, and there isn't really a way to organize them differently so that qlik doesn't combine them. How do I stop qlik from combining historic figures from e.g. sales revenue and sales quantity from 2003.

Thanks,

Lukas

1 Solution

Accepted Solutions
rupamjyotidas
Specialist
Specialist

Three Methods:

1) Alias or Rename

2) Concatenate

3) Qualify

Pick Any.

View solution in original post

5 Replies
bellamae
Specialist
Specialist

You could qualify the tables, which will put the name of the table in front of the fields.

e.g.

Qualifiy *;

TableName:

Load

Field1,

Field2

FROM .....

Unqualifiy *;

will result in fields called TableName.Field1 and TableName.Field2

rupamjyotidas
Specialist
Specialist

Three Methods:

1) Alias or Rename

2) Concatenate

3) Qualify

Pick Any.

Not applicable
Author

Thank you both, I will try to work it out.

jagan
Partner
Partner

Hi,

You can also try

  • Link Table
  • Joining Tables

Regards,

Jagan.

Serena07
Contributor II
Contributor II

hello Jagan,

could you please explain how to remove synthetic keys using Link Table?

 

Regards

Serena