Data Excluding

[KC3]

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

[sidhiq91]

@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.