topic Re: acces variable in inline object in QlikView

acces variable in inline object

Thu, 06 Sep 2012 09:37:17 GMT

hello

here is my code

threshold:

LOAD * INLINE [

key, warningv, errorv

'test1', 6500, 7000

'test2', 3000, 4000

'test3', 2500, 2000

];

testtable:

inner join(threshold)

LOAD 'test1' as key,

@1 as timetest1,

@2 as s2,

@3 as s3,

@4 as s4,

@2+@3+@4 as mysum,

if (@2+@3+@4 < warningv ,'green', 'red' ) as availability

FROM

....

With warningv it does not work, how can I user variable in order to compare @2+@3+@4 with 6500 (value of warningv in test1 from threshold table)?

thks

valery

Re: acces variable in inline object

daveamz — Thu, 06 Sep 2012 09:57:18 GMT

Hello,

Try something like:

threshold:
LOAD * INLINE [
key, warningv, errorv
'test1', 6500, 7000
'test2', 3000, 4000
'test3', 2500, 2000
];
testtable:
inner join(threshold)
LOAD 'test1' as key,
     @1 as timetest1,
     @2 as s2,
     @3 as s3,
     @4 as s4,
       @2+@3+@4 as mysum
     //if (@2+@3+@4 < warningv ,'green', 'red' ) as availability
FROM
....
threshold1:
LOAD
key,
warningv,
errorv,
timetest1,
s2,
s3,
s4,
mysum,
if(mysum<warning, 'green', 'red') as as availability
Resident threshold;
drop table threshold;

Regards,

David

Re: acces variable in inline object

Thu, 06 Sep 2012 10:16:45 GMT

hello

thks for your response. I am new in QV. Why do you drop threshold?

moreover why don't you drop also testtable?

what's the goal of droping table? memory space?

thk

Valery

Re: acces variable in inline object

daveamz — Thu, 06 Sep 2012 10:28:20 GMT

Otherwise QV will try to link the tables by common keys and you will end up with synthetinc keys which you must avoid.

Also, you can comment the drop line to see what happens.Testing is one way of learning. 🙂

Good luck,

David

Re: acces variable in inline object

Thu, 06 Sep 2012 11:42:33 GMT

thks a lot for your help