Button action (select in field) with condition

[#1]

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

[Gysbert_Wassenaar]

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.

[rubenmarin1 · Accepted solution]

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')

[#4]

Thanks Ruben, I didn´t believe that solution would be that simple. Now my button works as I wanted.