Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

Avoiding Synthetic Keys in Multiple Data Connections

Hello!

I have 5 excel sheets I am using for an app and each sheet has the following columns:

Year

Month

Quarter

PScore

HScore

Obviously, they cause a synthetic key because they are duplicated for the most part. I can't change the format of the excel sheet but is there something I can do in Qlik to avoid this? Would renaming them be the key to avoiding it?

Thank you1

Updated file

16 Replies
passionate
Specialist
Specialist

Why don't you use a link table

hammermill21
Creator III
Creator III
Author

I have obviously added the Source file incorrectly because it still happening. I have attached my new updated file to the original message.

Thank you for your help, I really appreciate it.

Anonymous
Not applicable

What viz has the incorrect figure in it and what is the figure and what should it be ?

Also what is the expression ?  I don't have the VizplumTextObject extension so cannot see what is happening in those 4 viz's, which is probably why I am confused.

hammermill21
Creator III
Creator III
Author

The Total Compliant Humidity count which is a KPI object is what is incorrect. The expression is: =Count({<HScore= {'1'}>} HScore), which should be 1277 and it's counting 2108. If I go check room by room I find that it is doubling the first count of rooms, which is coming from the main tab in the backend. The one you recommend I should leave the script as is (2018 Humidity March as is, as that will be creating the Final table to later be concatenated onto.). So I'm wondering if I should have added something to the script also?

Anonymous
Not applicable

Your first 3 script tabs are :

  • Main
  • Section
    • LIB CONNECT TO 'Smartsheet DSN - 2018 March OR Humidity Monitor (uhealth_54171224)';
    • Loads ...  FROM "2018 OR Humidity Monitor March__1357343347763076s_(Home)"
  • 2018 Humidity March
    • LIB CONNECT TO 'Smartsheet DSN - 2018 March OR Humidity Monitor (uhealth_54171224)';
    • Loads ...  FROM "2018 OR Humidity Monitor March__1357343347763076s_(Home)"

And from a quick eyeball tabs Section & 2018 Humidity March look the same, so you could well be loading some data twice.

Is that what you intend ?

hammermill21
Creator III
Creator III
Author

OH MAN!!! I was loading it twice!!! What a foolish mistake, I think I was testing and must have duplicated it.

I'm sorry to have wasted your time with that!

Thank you again.

Anonymous
Not applicable

No worries, it is easy to go snowblind after staring at a script all day and then not see the blindingly obvious - I do it more often than I care to admit.