Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have prepared my data model and loaded the tables via Data Manager in QLik Sense.
After creating the Dashboard, doing some checks against the table in the DB, I noticed that some duplicate rows had been eliminated. I realize it may seem strange, but for the work I do, duplicates are important and I cannot allow them to be eliminated.
Is there a way to forcefully load the tables as per my needs? I imagined there might be a setting that escapes me that is useful for this purpose.
Thank you very much for your availability.
You may have added a DISTINCT statement to a load and/or applied any explicit/implicit filtering - explicit means applying a where-clause and implicit any join-statement. Be aware that merging tables per join/concatenate the DISTINCT worked in both directions - not only the one in which it was called.