Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
QlickySense
Creator
Creator

Merge two numeric variables into one

Hello. I would like to merge two numeric variables into one. Please note that they are stored in 2 separate tables

Please find below capture of what I would like to achieve. Tried concatenate load/join but does not work as intended

Thank you for your help and have a nice day!

Labels (2)
10 Replies
marcus_sommer

Yes, removing the qualify may have a big effect within the script and all the UI dimensions/expressions and the resulting efforts to adjust everything might be really huge and even greater as re-creating the application from the scratch. Nevertheless I suggest to consider the last very carefully because maintaining a bad designed application could become a bigger nightmare as starting at the beginning again by applying all learnt things from the last months/years ...

In your special case you may directly before this load set an:

unqualify *;

and afterwards you enables it again with:

qualify *; // respectively with those fields which should be regarded for it

- Marcus