Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikians,
I wanted to exclude some data please help me with it in qlik view we usually use where formula
So my header name is Sales Type in this there are different lines sales1, sales2. sales3, sales4, sales5, sales6. Wanted to exclude sales2, sales3, sales5.
Please help me with the formula wanted to write in Script.
Thanks
KC
@KC3 Please see the script below:
NoConcatenate
Temp:
Load * inline [
Salestype
sales1
sales2
sales3
sales4
sales5
sales6
];
NoConcatenate
Temp1:
Load *
Resident Temp
where not match(Salestype ,'sales2','sales3','sales5');
Drop table Temp;
exit Script;
If this resolve your issue, please like and accept it as a solution.