Creating flag to identify primary dataset

[r_wroblewski]

Dear Community

I try to create a flag to identify the primary data set in the script.

I have a field called datatype where 1,2 or 3 is possible for same date.

Numbers can be interpreted as 1=received, 2=expected, 3=planned.

Please see attached qvw and excel file as example.

What I try to achieve: (same date)

1) datatype 1,2 and 3          1 flagged as primary

2) datatype 1 and 3              1 flagged as primary

3) datatype 2 and 3               2 flagged as primary

4) datatype only 3                  3 flagged as primary

I also need all data sets in my application for comparison.

I tried different approaches like FirstSortedValue but couldn't achieved what I need.

Most likely I just missed something simple but if anyone has any ideas I would be very grateful.

Best regards,

Ronny

[r_wroblewski · Accepted solution]

Dear Community,

I could solved this issue by myself after reading following thread:

http://community.qlik.com/message/662021#662021

and will mark this thread as answered.

Best regards,

Ronny