topic Conditional Flag in QlikView

Conditional Flag

hkg_qlik — Mon, 13 Aug 2012 19:19:45 GMT

Hi,

I have a table with Member ID as field name. Now I want to flag those Member ID's which are repeated in the table (More than once) while loading the table.

Regards,

Re: Conditional Flag

Mon, 13 Aug 2012 19:24:28 GMT

While loading the table, order by Member ID, assign 1 to Flag, peek previous Member ID, if it matches the current Member ID, increment Flag by 1 else next Member ID.

Re: Conditional Flag

jonathandienst — Mon, 13 Aug 2012 19:27:02 GMT

Something like this:

LOAD MemberID,

If(Exists(MemberID), 1, 0) As RepeatFlag,

...

From Table;

Regards

Jonathan

Re: Conditional Flag

jonathandienst — Mon, 13 Aug 2012 19:30:09 GMT

Or something like this (after having loaded the data into a resident table):

Join(Table)

LOAD MemberID,

Count(MemberID) As IDCount,

Resident Table

Group By MemberID;

Regards

Jonathan