How to do this in Qlikview

[#1]

Hi Experts

I want this in Qlikview Script:

Main File Data:

Desired Output:

Sample File is Attached for Reference.

Regards

Eric

[#2]

Here is a sample for how you could limit the load in the script:  (I am basing this on what looks like your primary limiters are Unique Case & Unique Category)

[sunny_talwar]

What is the logic that is driving the output you are looking for?

[settu_periasamy]

Seems to be you want the first value in the 'ID'.

May be try like..

LOAD Case,
Flag,
Category,
FirstValue(ID) as ID
  FROM
Sample_Logic.xlsx
(ooxml, embedded labels, table is Sheet1) Group by Case,Flag,Category;

[varshavig12]

Script:

Directory;

LOAD Case,

     Flag,

     Category,

     firstvalue(ID) as ID

FROM

a.xlsx

(ooxml, embedded labels, table is Sheet1)

Group by Category,Case,Flag;

Dimesion:

Expresssion:

if(Category<>above(Category),ID)

Output:

[phaneendra_kunc]

Seems he is looking load only first occurrence.

You can do with FirstValue() or Previous() with if statement.

[varshavig12]

I guess, one can do this with aggr function.

[sunny_talwar]

But then why did GHI 3 Wrong not included in the result?

[phaneendra_kunc]

He is picking up/ going by Category not on Flag.

[jonathandienst]

Perhaps the original poster would like to comment on the speculation here.