Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
Yes, you can use a preloaded variable in where condition of inline load.