Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
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

View solution in original post

2 Replies
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

View solution in original post

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