Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
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
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;
Hi
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>
This is exactly what my suggestions will do. Give it a try. Maybe you'll need to clarify your requirements after that.