Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with many fields, but i want to restrict the data in the script by using company, brands and spend amount fields.
There are scenarios where there will be companies without brands and spend amount, so i want to restrict these records where the spend amount is 0 and no brands for a company.
There are scenarios where there will be companies and brands, but spend amount will be 0, so i want to restrict these records as well in the script.
How to achieve this in QlikView script?
look for WHERE statement
Load * From..
WHERE SpendAmount>0 and not isnull(Brand)
or similar syntax..
look for WHERE statement
Load * From..
WHERE SpendAmount>0 and not isnull(Brand)
or similar syntax..
May be like this:
Table:
LOAD Company,
Brand,
SpendAmount
FROM .....
Where SpendAmount > 0;
Your first condition is met by the overarching second condition