Discussion board where members can get started with Qlik Sense.
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.
Date(MonthStart(Date#(Month_Filter, 'MMM YYYY')), 'MMM YYYY') as Month_Filter,
[Sample Data (2).xlsx]
(ooxml, embedded labels, table is Sheet1);
Min(Month_Filter) as Month_Filter,
1 as Flag
Where New_Field = 'OK'
Group By User;
If(Flag = 1, 'TRUE', 'FALSE') as [Desired Output]
DROP Table Table;