Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
afuchten
Valued Contributor

Store qvd file

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:

CONCATENATE (ResponseTimes)

LOAD *

FROM $(vDirectory)\ResponseTimes.qvd (qvd)

WHERE NOT EXISTS(ResponseTimes.ResponseKey)

;

vovan4ik
Valued Contributor II

Store qvd file

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?

  CONCATENATE

  LOAD DISTINCT * FROM $(vQVD)\1.qvd (QVD)

WHERE NOT EXISTS (MYear) AND date(submitDateTime)>=date('$(dDate)') 

Thanks,

vovan4ik
Valued Contributor II

Store qvd file

I found out solution

  CONCATENATE

  LOAD DISTINCT * FROM $(vQVD)\1.qvd (QVD)

WHERE NOT EXISTS (ID) AND date(submitDateTime)>=date('$(dDate)')