Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
field names are case sensitive, so shouldn't it be upper case?
=chr(39) & Country & chr(39)
If possible, create and post a small sample app.
Thanks, the hint with chr(39) is great!
Now I've got a variable Vcountry with 'France'.
How do I get this Vcountry into my expression?
, Country={$(Vcountry)}, doesn't work.
Not sure why it does not work. It would be easier if you could provide a small sample application.
Like attached..,