topic Re: Check if value exists within group in QlikView

Check if value exists within group

nigel987 — Tue, 24 Jan 2017 17:05:11 GMT

Hi,

I have several IDs and Date. Whenever the same Date occurs more than once within a group, I'd like to set the field Bulk as 'Yes', else 'No'.

Any idea which formula I can use? With peek I always miss the first entry.

Here's an example how the result should look like:

Thanks for any hint!

sunny_talwar — Tue, 24 Jan 2017 17:07:37 GMT

May be this:

Left Join (Table)

LOAD ID,

Date,

If(Count(Date) >= 2, 'Yes', 'No') as Bulk

Resident Table

Group By ID, Date;

nigel987 — Tue, 24 Jan 2017 17:26:13 GMT

Thanks!