topic Re: Re: reference line expression in QlikView

reference line expression

samuel_brierley — Wed, 16 Apr 2014 09:10:40 GMT

Hi all,

first of all thanks for any and all help its much appreciated.

I want to add a reference line onto a chart but I want the reference line to be a value from an excel table.

this table is not releated to the data on the chart and a lookup in the script seems to take FARRRRR too long so thats out.

id like the line to show the value of RLev10 in the table.

Parameter:	Value:
RLev10	750

thanks for any help.

Re: reference line expression

samuel_brierley — Wed, 16 Apr 2014 09:12:16 GMT

apologies i forgot to add the name of the table is Settings, im pretty sure this will be required.

thanks again

Re: reference line expression

MK_QSL — Wed, 16 Apr 2014 09:14:09 GMT

Go to Presentation >> Reference Lines >> Add >> Expression >> =RLev10 or =750

Re: reference line expression

samuel_brierley — Wed, 16 Apr 2014 09:18:24 GMT

Doesnt work,

I cant just put 750 as im trying to make a temp[late that will work regardless of the input data.

Re: reference line expression

MK_QSL — Wed, 16 Apr 2014 09:22:14 GMT

Can you share your sample data or apps or even a picture of your current chart?

Re: reference line expression

samuel_brierley — Wed, 16 Apr 2014 09:30:49 GMT

Ye no Prob

on the chart I just need a reference line that shows rLev10 in the table Settings( in this version I havent named the table so its just called Sheet1), you can see that this isnt related if you look in table viewer you will see the standalone table.

also If you know how would it be possible to add a referene line that is Y=X?

https://www.dropbox.com/s/0r9kv1wo1jlq4wk/multidays.qvw

Re: reference line expression

maxgro — Wed, 16 Apr 2014 09:33:40 GMT

load your excel and see image

Re: reference line expression

samuel_brierley — Wed, 16 Apr 2014 09:40:45 GMT

thanks youve definalty sussed it but how did you specify to puse the value for RLev10?

Re: reference line expression

jfkinspari — Wed, 16 Apr 2014 09:49:26 GMT

Just type RLev10 into the expression. It's where Massimo has written Value

Re: reference line expression

samuel_brierley — Wed, 16 Apr 2014 09:57:32 GMT

Hi,

I have entered into the box (spelling and Case is correct) but no line appears?

Re: reference line expression

jfkinspari — Wed, 16 Apr 2014 10:00:34 GMT

The expression is red, meaning it cant find the field in the datamodel.

Make sure you have load the field value from the Excel sheet.

Eventual you can upload a sample of the qvw file.

Re: reference line expression

Roop — Wed, 16 Apr 2014 10:00:40 GMT

Your expression needs to be = 750, or if you want to make it more variable make it equal to a variable that you then give the value of 750 to

Re: reference line expression

maxgro — Wed, 16 Apr 2014 10:03:59 GMT

if you laded your excel and it has 1 record and the name of the field is Value (Value=750), put

Value in expression

Re: reference line expression

samuel_brierley — Wed, 16 Apr 2014 10:06:31 GMT

thats because my Field is named Paramater and the record is rLev10, their are obviously other records in this table but for this reference line I only require rLev10, apologies if that wasnt clear

Re: reference line expression

Roop — Wed, 16 Apr 2014 10:11:26 GMT

Your Rlev10 does not exist as it has a red underline in the window. I think that this is just a problem of spelling or upper/lower case - these need to be exact. I would suggest selecting RLev10 from your field names already defined in your expression.

Re: reference line expression

samuel_brierley — Wed, 16 Apr 2014 10:18:16 GMT

rLev10 really does exist and im 100% ive spet it correct, the reason it is red is because it is a record not a field.

Re: Re: reference line expression

maxgro — Wed, 16 Apr 2014 10:20:08 GMT

the expression should be

=only( {1 <Parameter={RLev10}>} Value)

example in the attachment

Re: reference line expression

samuel_brierley — Wed, 16 Apr 2014 10:22:48 GMT

Thank You very much, I sense that was far more difficult than it should be lol,

have a nice day

Re: reference line expression

Roop — Wed, 16 Apr 2014 10:26:21 GMT

See Massimo Grossi answer - sorry had not realised it was a parameter inside a table.