topic Set variable value when a certain selection is made in QlikView

Set variable value when a certain selection is made

Fri, 19 Sep 2014 14:01:52 GMT

I'm trying to set variable vButton=1 when the current year is selected and no selections are made in other calendar fields (QUARTER, MONTH, MONTH-YEAR). This will change the color of my YTD button.

I tried to add a Trigger Action under Document Properties, but the Field Event Triggers don't allow me to prescribe a condition like below. Can anyone help??

(GetFieldSelections(YEAR)=YEAR(Today()),vButton=1)

Re: Set variable value when a certain selection is made

maxgro — Fri, 19 Sep 2014 21:04:18 GMT

to change the color of a button add an expression for Calculated in the color of the button

something like (adapt to your requirement)

=if(GetPossibleCount(SerialNumber)=1 and GetPossibleCount(Year)=1,red(), green())

I don't think you need a variable and/or trigger

Re: Set variable value when a certain selection is made

sundarakumar — Sun, 21 Sep 2014 05:02:10 GMT

create a calculated color for the text box (background) like

=if(getselectedcount(year)=1 and getselectedcount(month)<>1 and getselectedcount(monthyear)<>1

, newcolor(), oldcolor());

-Sundar