Discussion Board for collaboration related to QlikView App Development.
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
Field = KPIdimEN
Search string = 'Customer groupings'
condition show = GetFieldSelections(Language)='English'
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?
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')
View solution in original post
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.
Thanks Ruben, I didn´t believe that solution would be that simple. Now my button works as I wanted.