topic Re: best way to filter when loading a table in QlikView

best way to filter when loading a table

Tue, 29 Jul 2014 16:11:40 GMT

Hi,

What is the best way to filter out something when loading a table? I have a table that has all different locations for a manufacturer but I would like to load only data for specific ones.

Example: I have different locations but I only want to bring in data for the locations that start with L1, (i.e L1_Missouri, L1_Florida, L1_Iowa)

Location

L1_Missouri

L2_Missouri

L1_Florida

L2_Florida

L1_Iowa

L2_Iowa

Re: best way to filter when loading a table

jaimeaguilar — Tue, 29 Jul 2014 16:50:09 GMT

Hi,

you can do it with wildcard searches using wildmatch or Like functions. You also have the static searches (where Location = L1_Florida.

You can also use variables that can be modified through an external file/inline table and be used as parameters for the where clause via UI input box or input during script execution,

check the attached example

regards

Re: best way to filter when loading a table

tobias_klett — Tue, 29 Jul 2014 16:52:53 GMT

Hi,
just use
where left(Location,2) = 'L1';

Hope this helps

Re: best way to filter when loading a table

its_anandrjs — Tue, 29 Jul 2014 17:04:29 GMT

From any field perspective you are asking then you can filter the records from the script load

Ex:- From Load script

Load

Location

from Source

Where

Left(Location,2) = 'L1';

Ex:- From the Front end by the flag field

LOAD Location,if( Left(Location,2)='L1',1,0) as Flag;

LOAD * Inline

[

Location

L1_Missouri

L2_Missouri

L1_Florida

L2_Florida

L1_Iowa

L2_Iowa

];

And on UI side write calculated dimension

If(Flag=1,Location) //And Suppress when value is null.