Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Code

Hi All

This is my first post to qlikview.

Can anybody help me in getting the below result.

Desired Output.png

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

Regards

Cire

Tags (1)
1 Reply
sunny_talwar
Not applicable

Re: Code

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;