Limiting the no. of rows in the data

[udaya_kumar]

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?

[robert_mika · Accepted solution]

look for WHERE statement

Load * From..

WHERE SpendAmount>0 and not isnull(Brand)

or similar syntax..

[sunny_talwar]

May be like this:

Table:

LOAD Company,

          Brand,

          SpendAmount

FROM .....

Where SpendAmount > 0;

Your first condition is met by the overarching second condition