topic Re: issue in Qlik Learning Discussions

issue

Mon, 16 Feb 2015 14:57:56 GMT

i have a problem

in below sheet i need to retail line which have only Stock(abc) and CustomsCleared(abc) if anything with CustomsCleared(abc)/xyz i need to remove that line and retain only the line which have Stock(abc) and CustomsCleared(abc) please help me on it i am new to qlickview and trying to learn new things

regards

sandeep

Re: issue

Anonymous — Mon, 16 Feb 2015 16:03:42 GMT

Not enough information, so I'll use assumptions:
1. You load data from this excel file into a QV app.
2. You want to eliminate records which contain '/' in the SupplyStatus

If this is true, than

LOAD
...
FROM...
WHERE wildmatch(SupplyStatus,'*/*')=0;

Re: issue

Mon, 16 Feb 2015 22:13:26 GMT

Thanks suggestion but i need to eliminate the line which contains any thing

after stock () and customs clearance() for example if it is customs

clearance()/ abc and one more line contains customs clearance() i need to

eliminate the line which have customs clearance()/abc and need to keep the

line which have customs clearance

Looking forward to hear from you

Regards

Sandeep

On 16-Feb-2015 9:34 PM, "Michael Solomovich" <qcwebmaster@qlikview.com>

Re: issue

Anonymous — Wed, 18 Feb 2015 15:59:45 GMT

This is exactly what my suggestions will do. Give it a try. Maybe you'll need to clarify your requirements after that.