topic Re: How to toggle (multiple) field values with an action button? in QlikView

How to toggle (multiple) field values with an action button?

Wed, 17 Jun 2015 13:27:37 GMT

Hi experts,

I am battling with an action button that allows me to switch between two field values. (QlikView 11.0)

I have a TURNOVER table that contains two date fields: %SLDate and %WLDate. Linked are the tables Date_SL and Date_WL.

With a button, I would like to assign the selected values of Date_WL.Month to Date_SL.Month and vice versa.

---->

This works fine, as long as I select only one value (e.g. ‘Jan’).

As soon as I select more than one value (e.g. ‘Jan’ & ‘Feb’) and press the button, the selection for both fields is empty.

---->

I use a variable that toggles between 1 and -1.

Further on I use two 'Select in Field'

for Date_WL.Month ( if($(vToggleDate)=1, GetFieldSelections(Date_SL.Month,',',15)) )

and Date_SL.Month ( if($(vToggleDate)=-1, GetFieldSelections(Date_WL.Month,',',15)) )

How can I make the function to accept multiple selections?

Thanks in advance for your help.

pokassov — Wed, 17 Jun 2015 15:46:46 GMT

Hello!

for multiple selection you have to use this format (value1|value2).

Try something like this:

=if($(vToggleDate)=1, '('&GetFieldSelections(Date_SL.Month,'|',15)&')')

maxgro — Wed, 17 Jun 2015 17:48:59 GMT

=if($(vToggleDate)=1, '("' & concat(DISTINCT Date_SL.Month, '"|"') & '")', '')

Fri, 19 Jun 2015 06:20:04 GMT

Thanks Sergey,

your solution works exactly as I need it.

Best regards,

Hermann