Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I wonder if it´s possible to add a condition to select in field action? My problem is that depending on other selections, button action should select from different fields. Here is example:
Select in field:
Field = if(GetFieldSelections(Language)='English', KPIdimEN, KPIdim)
Search string = if(GetFieldSelections(Language)='English', 'Customer groupings', 'Something else')
I have tried above mentioned action but with no success. Or is solution to add multiple buttons with condition show? For example
1. button:
Field = KPIdimEN
Search string = 'Customer groupings'
condition show = GetFieldSelections(Language)='English'
2. button:
Field = KPIdim
Search string = 'Something else'
condition show = GetFieldSelections(Language)='Finnish'
My problem is more complex and I should add at least 6 buttons, that´s why I´m asking is there another way to solve this?
Thanks!
Suvi
Hi, for Field expression quote the field name so if returns the string, not the value of the field:
Field = if(GetFieldSelections(Language)='English', 'KPIdimEN', 'KPIdim')
Perhaps this blog post will give you ideas: Handling Multiple Languages. Don't forget to take a look at the technical brief document in How to Handle Multi-Language Translations in QlikView.zip too.
If you want to do this with buttons and select in field actions (not recommended) see attached example.
Hi, for Field expression quote the field name so if returns the string, not the value of the field:
Field = if(GetFieldSelections(Language)='English', 'KPIdimEN', 'KPIdim')
Thanks Ruben, I didn´t believe that solution would be that simple. Now my button works as I wanted.