topic Re: Load inline with condition based on variable in QlikView

Load inline with condition based on variable

Sat, 19 Apr 2014 00:56:42 GMT

I have a simple inline script -

LOAD * INLINE [

Name, Age

Jon, 11

Ash, 15

Sam, 10

Ashley, 5

Carla, 3

David, 7

];

Is there a way to load only those rows which meet a condition specified by a variable ?

Eg. LOAD ....

];

WHERE Age = myQlikViewVariable

Re: Load inline with condition based on variable

mambi — Sat, 19 Apr 2014 01:30:26 GMT

yes of course,

for exemple if you've already defined a variable : set vAge = 10;

then you can use it like this :

set vAge = 10;
LOAD * INLINE [
     Name, Age
     Jon, 11
     Ash, 15
     Sam, 10
     Ashley, 5
     Carla, 3
     David, 7
] Where Age >= $(vAge);

Re: Load inline with condition based on variable

Sat, 19 Apr 2014 03:55:45 GMT

Yes, you can use a preloaded variable in where condition of inline load.