Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stekol61
Contributor

Referense line expression

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

1 Solution

Accepted Solutions
micheledenardi
Valued Contributor

Re: Referense line expression

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


9 Replies

Re: Referense line expression

You can try this

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

micheledenardi
Valued Contributor

Re: Referense line expression

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


Re: Referense line expression

Or this also

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


Or


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


Or


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

Re: Referense line expression

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


or


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

stekol61
Contributor

Re: Referense line expression

This solved my problem.

Thank You

micheledenardi
Valued Contributor

Re: Referense line expression

Hi Stefan,

can you mark as correct the right answer ?
Thanks

stekol61
Contributor

Re: Referense line expression

how do I mark it as correct?

micheledenardi
Valued Contributor

Re: Referense line expression

Press the green Star button correspondig to the correct answer

2017-09-08 17_06_57-Applymap with dynamic table name _ Qlik Community.png

stekol61
Contributor

Re: Referense line expression

Done

Community Browser