3 Replies Latest reply: May 2, 2014 12:43 PM by Stefan Wühl RSS

    Substitution of varables in an expression

    Klaus Huber

      Hello,

       

      I have got the following expression in a text-field:

      =count({<ValueType={'Count'}, Country={'Germany'}>} Value)

      This works fine.

       

      Now I want to make it flexible: Instead of 'Germany' I want to use a variable. This variable is set by a trigger from a field and a listbox.

      If I choose France from the listbox I take this triffer:

      Actions - Set Variable - Varible: Vcountry - Value: "'" & country & "'"

       

      I tried the hints from the blog from Henric Cronstöm but with not success:

      http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

       

      I tried to change 'Germany' into $(Vcountry) but it doesn't work.

       

      Can anyone give me a hint?

       

      Thanks

       

      Klaus