Code

[#1]

Hi All

This is my first post to qlikview.

Can anybody help me in getting the below result.

Here, I need to pick the First OK Status User wise.

Regards

Cire

[sunny_talwar]

Try this:

Table:

LOAD User,

    Date(MonthStart(Date#(Month_Filter, 'MMM YYYY')), 'MMM YYYY') as Month_Filter,

    New_Amount,

    New_Field

FROM

[Sample Data (2).xlsx]

(ooxml, embedded labels, table is Sheet1);

Left Join(Table)

LOAD User,

  Min(Month_Filter) as Month_Filter,

  1 as Flag

Resident Table

Where New_Field = 'OK'

Group By User;

FinalTable:

LOAD User,

  Month_Filter,

  New_Amount,

  New_Field,

  If(Flag = 1, 'TRUE', 'FALSE') as [Desired Output]

Resident Table;

DROP Table Table;