Discussion Board for collaboration related to QlikView App Development.
If the rows have a unique key, use that key to filter out the duplicates . . .
We joined some columns to one field as a key field . . . then you got something like this:
FROM $(vDirectory)\ResponseTimes.qvd (qvd)
WHERE NOT EXISTS(ResponseTimes.ResponseKey)
Please help me with script
I load current month in a script, then concatenate with historical data.
I use many qvw files which load the same qvd file. I get double count for CURRENT month. How can I fix that?
LOAD DISTINCT * FROM $(vQVD)\1.qvd (QVD)
WHERE NOT EXISTS (MYear) AND date(submitDateTime)>=date('$(dDate)')
I found out solution
WHERE NOT EXISTS (ID) AND date(submitDateTime)>=date('$(dDate)')