topic Referense line expression in QlikView

Referense line expression

stekol61 — Fri, 08 Sep 2017 13:38:30 GMT

I have creaded a reference line based on values from a loaded excel file.

=only( {1 <Graph_num={1}>} [Limit(%)])

I can switch between differen graphs by changing a variable (v_graphtype).

This variable correspond to the {1} in the expression.

How could i create an expression that uses my variable instead of a fixed value?

/Stefan

its_anandrjs — Fri, 08 Sep 2017 13:42:01 GMT

You can try this

=only( {1 <Graph_num={"=(=v_graphtype)"}>} [Limit(%)])

micheledenardi — Fri, 08 Sep 2017 13:43:26 GMT

only( {1 <Graph_num={'$(vVariable)'}>} [Limit(%)])

its_anandrjs — Fri, 08 Sep 2017 13:44:13 GMT

Or this also

=only( {1 <Graph_num={'=$(=v_graphtype)'}>} [Limit(%)])

=only( {1 <Graph_num={'$(v_graphtype)'}>} [Limit(%)])

Kushal_Chawda — Fri, 08 Sep 2017 13:46:03 GMT

only( {1 <Graph_num={"$(=v_graphtype)"}>} [Limit(%)])

only( {1 <Graph_num={"$(v_graphtype)"}>} [Limit(%)])

stekol61 — Fri, 08 Sep 2017 13:57:32 GMT

This solved my problem.

Thank You

micheledenardi — Fri, 08 Sep 2017 14:01:52 GMT

Hi Stefan,

can you mark as correct the right answer ?
Thanks

stekol61 — Fri, 08 Sep 2017 14:05:59 GMT

how do I mark it as correct?

micheledenardi — Fri, 08 Sep 2017 15:09:58 GMT

Press the green Star button correspondig to the correct answer

stekol61 — Mon, 11 Sep 2017 07:00:41 GMT

Done