topic Load Distinct records in QlikView

Load Distinct records

Mon, 20 Jul 2009 19:06:51 GMT

Hi,

My client gimme the call data month wise.
If one call ages till next month, it will appear two times - one in previous month and another in current month data.
After loading both months' data, Count(Problem_ID) gives different than that of Count(Distinct Problem_ID).

Instead of writing Distinct in every chart, will it be possible to use the distinct keyword at Load script itself.

I tried like...
Load Distinct Problem_ID,
Problem_Desc,
...,
...;
but its not working.

Any suggestion!!

Thanks & Regards,
Arun Mittal

Load Distinct records

prieper — Mon, 20 Jul 2009 19:34:37 GMT

Hi,

your script with LOAD DISTINCT ... should solve the problem, provided all the fields other than the key are identical.

If you load from different files using "*", it might be wise to load all the data first and then to review all the data with the DISTINCT-parameter

HTH

Peter

Load Distinct records

rwunderlich — Tue, 21 Jul 2009 01:28:32 GMT

It sounds like you want only the latest record for each Problem_ID. Ensure you load from newest file to oldest file and include the clause

WHERE NOT EXISTS(Problem_ID)

-Rob

Load Distinct records

Wed, 22 Jul 2009 16:14:40 GMT

Thanks Rob

Thanks Peter