Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

Tags (1)
1 Solution

Accepted Solutions
rupamjyotidas
Not applicable

Re: Remove synthetic keys

Three Methods:

1) Alias or Rename

2) Concatenate

3) Qualify

Pick Any.

4 Replies
bellamae
Not applicable

Re: Remove synthetic keys

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
Not applicable

Re: Remove synthetic keys

Three Methods:

1) Alias or Rename

2) Concatenate

3) Qualify

Pick Any.

Not applicable

Re: Remove synthetic keys

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

jagan
Not applicable

Re: Remove synthetic keys

Hi,

You can also try

  • Link Table
  • Joining Tables

Regards,

Jagan.