Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

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
Specialist II
Specialist II

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


Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

9 Replies
its_anandrjs

You can try this

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

micheledenardi
Specialist II
Specialist II

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


Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
its_anandrjs

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(%)])

Kushal_Chawda

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


or


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

stekol61
Creator
Creator
Author

This solved my problem.

Thank You

micheledenardi
Specialist II
Specialist II

Hi Stefan,

can you mark as correct the right answer ?
Thanks

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
stekol61
Creator
Creator
Author

how do I mark it as correct?

micheledenardi
Specialist II
Specialist II

Press the green Star button correspondig to the correct answer

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
stekol61
Creator
Creator
Author

Done