Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
I want this in Qlikview Script:
Main File Data:
Desired Output:
Sample File is Attached for Reference.
Regards
Eric
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)
What is the logic that is driving the output you are looking for?
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;
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:
Seems he is looking load only first occurrence.
You can do with FirstValue() or Previous() with if statement.
I guess, one can do this with aggr function.
But then why did GHI 3 Wrong not included in the result?
He is picking up/ going by Category not on Flag.
Perhaps the original poster would like to comment on the speculation here.