Qlik Community

Qlik Sense App Development

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

nandhaadjame200
New Contributor II

Synthetic Key Question - on Month & Region field which i'm using as filters

Hi There

Synthetic Key Question - on Month & Region field which i'm using as filters:

I'm having multiple tables with same set of fields which is really required for filters. If i rename or concatenate those fields, then i will not have separate fields for filter's. Also those filters were common for all dashboards which i created. 

Also I've attached my Data Model screenshot for reference.

Please check and advise if can continue with those synthetic keys or i should really worry about my data model.

 

Thanks

Nandhakumar

1 Solution

Accepted Solutions
Highlighted
jyothish8807
Honored Contributor II

Re: Synthetic Key Question - on Month & Region field which i'm using as filters

Hi Nandha,

Try like this:

Make a new key "Month &'|'& Region" in all the tables which have month and Region field and drop this filed from all the tables except the one which have all the month and region data (Master Table).

Table A:

Load

Month,

Region,

Month &'|'& Region as %Key

from Table A;

 

B:

Load

//Month,

//Region,

Month &'|'& Region as %Key

from Table B;

Do this for other tables as well. It will help in eliminating the synthetic keys and result in star schema.

Hope it helps.

Best Regards,
KC
2 Replies
Highlighted
jyothish8807
Honored Contributor II

Re: Synthetic Key Question - on Month & Region field which i'm using as filters

Hi Nandha,

Try like this:

Make a new key "Month &'|'& Region" in all the tables which have month and Region field and drop this filed from all the tables except the one which have all the month and region data (Master Table).

Table A:

Load

Month,

Region,

Month &'|'& Region as %Key

from Table A;

 

B:

Load

//Month,

//Region,

Month &'|'& Region as %Key

from Table B;

Do this for other tables as well. It will help in eliminating the synthetic keys and result in star schema.

Hope it helps.

Best Regards,
KC
nandhaadjame200
New Contributor II

Re: Synthetic Key Question - on Month & Region field which i'm using as filters

HiJyothish

Apologies for the delayed response.

Actually, your solution worked for me. Thanks a lot.

Thanks

Nandhakumar