topic Re: Button action (select in field) with condition in QlikView

Button action (select in field) with condition

Thu, 25 Sep 2014 06:55:27 GMT

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

Re: Button action (select in field) with condition

Gysbert_Wassenaar — Thu, 25 Sep 2014 09:12:37 GMT

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.

Re: Button action (select in field) with condition

rubenmarin — Thu, 25 Sep 2014 09:34:46 GMT

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

Re: Button action (select in field) with condition

Thu, 25 Sep 2014 09:39:26 GMT

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