This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I need a help in flagging data on base of above and below criteria in load script.
IF any data contains " | RR | BS | " then count as 1
But IF any data contains " | RR | AC | " with above Same Num & Ref number then count as -1
But IF any data contains " | RR | AC | " with below Same Num & Ref number then count as 0
I have attached sample file for your reference.
Can u try this?
SubField(Data,'|',1) as Num,
SubField(Data,'|',SubStringCount(Data,'|')+1) as Ref,
SubField(Data,'|',1)&SubField(Data,'|',SubStringCount(Data,'|')+1) as Group,
FROM [lib://downloads/Need Help.xlsx]
(ooxml, embedded labels, table is Sheet1) ;
load *, RowNo() as row, if(Index(Data,' | RR | BS | ' )<>0,1
if(Index(Data,' | RR | AC | ' )<>0 and Group=previous(Group),-1
as Index1 Resident Table Order by Group;
drop table Table;
load * , if (len(Index1)=0 and len(Index2)=0,'',if(len(Index1)=0,Index2,Index1)) as Count ;
load *,if(Index(Data,' | RR | AC | ' )<>0 and Group=previous(Group),0) as Index2
Resident Table1 order by row desc;
drop table Table1;
drop Fields row,Index1,Index2 from Final;
And see if it does the work?
View solution in original post
Thank you 🙂 It worked.
Well... that.. was... quick !
Yes, Thank you.
But I am stuck again. I need add 1 more different calculation. I have attached a file.
Please help me on it.