topic Distinct for a single field in QlikView

Distinct for a single field

Fri, 21 Jan 2011 13:37:42 GMT

Hey experts,

I have four fields in a table,1. chequeID 2. agreementID 3. LOSID 4. lesseID

what i want is :: unique values in chequeID , and not for the whole table.

i can use distinct for the whole table but not for a single field, can anybody guide me how to do for a single field ???

Distinct for a single field

johnw — Sat, 22 Jan 2011 01:52:48 GMT

The answer is probably simple, but I have no idea what you're asking. Are you talking about script? Creating a table in script with unique values of chequeID? Showing unique values in a chart? Counting unique values? What are you after?

Distinct for a single field

Mon, 24 Jan 2011 13:12:10 GMT

Dear John,

One table with 4 fields, one of the field name is chequeID and tht should be unique, and not the whole table fields,

I dont want to use distinct for the whole table and when i use distinct for only chequeID it says 'invalid function'

Is their any other way to do this rather than doing it in charts / graphs,

Thanking your anticipation.

Regards,

Prashant A...

Distinct for a single field

tresB — Mon, 24 Jan 2011 13:31:04 GMT

As John was asking if you want this in script, is not clear even now.Still, assuming that you are expecting it so, try to load your data with like:

Load field1, field2,...... From.....Where Not Exists(ChequeID);

Regards, tresesco