topic How to filter in script level? in QlikView

How to filter in script level?

Mon, 08 Sep 2014 06:38:56 GMT

i have employess expenses data

empid ,Amount,employee name

but some each employee has many expenses first i want some of all the expenses and after that i want >10000 expenses

now i want to display ony >10000 expenses

how implement this is in script level not in desgin level

please

Re: How to filter in script level?

PrashantSangle — Mon, 08 Sep 2014 06:48:21 GMT

Hi,

Try like this,

Load

only(empid) as empid,

Sum(Amount) as Expenses,

Employee name

from tableName

where Sum(Amount)>10000

Group by Empoyee name

Regards

Re: How to filter in script level?

senpradip007 — Mon, 08 Sep 2014 06:49:05 GMT

You can try like:

Load

empid ,

Amount,

[employee name]

From <>

where Amount>10000;

Re: How to filter in script level?

Mon, 08 Sep 2014 06:56:15 GMT

Hi,

for applying filter into Script Level you can use Where Clause

Like first Load all the data

All_Data :

Load *

From Source_Table;

Then use Resident Load

Filterd_data :

Load *

Resident All_Data

where expenses>10000;

Then Drop the All_Data Table :

Drop Table All_Data;

Regards,

Vivek

Re: How to filter in script level?

Anonymous — Mon, 08 Sep 2014 06:57:49 GMT

Use following script>>>

TEMP:

Load

empid as empid,

Sum(Amount) as Expenses,

[Employee name]

from <table name>

Group by empid,[Employee name];

NoConcatenate

Final:

LOAD * Resident TEMP

where Expenses>10000;