topic Re: Change color of the button by an exact match with the selection of the user in QlikView

Change color of the button by an exact match with the selection of the user

Anonymous — Wed, 04 May 2016 07:22:38 GMT

Hi together,

does anyone know how to write the condition for the inquiry if the months of the actual year are selected by the user?

I want that the button is colored black when the selection of the User corresponds with the set standard selection of the button.

Light grey= not active

Black= active

Goal: Today > May 2016

If the user select exaxtly: 2016 + 01, 02, 03, 04, 05 then the button should be black

That are the settings of the button:

=If(GetFieldSelections(Jahr)= year(today()) and GetFieldSelections(Monat)<= month(today()), 'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')

The red part is wrong. By this way the button is black once a month selected by May.

Correct should be:

=If(GetFieldSelections(Jahr)= year(today()) and GetFieldSelections(Monat)= '01, 02, 03, 04, 05', 'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')

But how to write something in a changeable form (dynamic)?

Greetings

Lisa

Re: Change color of the button by an exact match with the selection of the user

sunny_talwar — Wed, 04 May 2016 22:35:27 GMT

How about this:

=If(GetFieldSelections(Jahr) = Year(Today()) and RangeMax($(=GetFieldSelections(Monat))) <= Num(Month(Today())),

'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')

Re: Change color of the button by an exact match with the selection of the user

Anonymous — Thu, 05 May 2016 04:23:57 GMT

go to the listboxand go to the action tab to give action selection in field to get the out put

Re: Change color of the button by an exact match with the selection of the user

qliksus — Thu, 05 May 2016 10:14:17 GMT

May replace it with something like

count({1<nMonth={"<=$(=max(nMonth))"}>}DISTINCT nMonth ) <=num(month(today())

Re: Change color of the button by an exact match with the selection of the user

perumal_41 — Fri, 06 May 2016 09:17:20 GMT

Try below

=If( GetFieldSelections(Jahr)= year(today()) and GetFieldSelections(Monat)= concat(ValueLoop(1,num(month(today())),1),', '), 'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')

Re: Change color of the button by an exact match with the selection of the user

Anonymous — Fri, 06 May 2016 13:18:40 GMT

Hi Perumal,

great ... thank you, it is working :-).

Will you please help me with the formatting?

I do not get it into the right form > I need two decimal places.

My experiments with the num function were unsuccessful.