topic Re: Activate Button based on selection in QlikView

Activate Button based on selection

ivandrago — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the attached Document, within there, there is a Button on the "Main" Sheet called Go to Sheet and when you click on it, it will go to the Sheet "Active Sheet".

I only want this button to be enabled if the field OriginalTable has been selected and has a value AND the field _AreaFlag is greater than 0 (Zero)

I have tried the following confition but it is not working

=Len(Trim(GetCurrentSelections(OriginalTable))) > 0 and _AreaFlag > 0

Thanks

Re: Activate Button based on selection

bc-thebruuu — Wed, 16 May 2018 13:07:38 GMT

Pls try the following condition:

Count(DISTINCT{<OriginalTable=p(OriginalTable),_AreaFlag={">0"}*p(_AreaFlag)>}Area)>0

and GetSelectedCount(OriginalTable)>0

Re: Activate Button based on selection

Anonymous — Wed, 16 May 2018 13:15:53 GMT

Hello Ivan,

You can try this:

=(Len(Trim(GetFieldSelections(OriginalTable))) > 0) and (_AreaFlag > 0)

Best regards,

Marco

Re: Activate Button based on selection

ivandrago — Wed, 16 May 2018 13:38:50 GMT

Hi, can this be done without the field "Area" in the formula?

Re: Activate Button based on selection

bc-thebruuu — Wed, 16 May 2018 13:40:37 GMT

You can count whatever is needed .. .the advantage of selecting Area is that with the distinct you'll get 0 or 1, according to data provided

Re: Activate Button based on selection

ivandrago — Wed, 16 May 2018 13:46:46 GMT

So what would the formula be if lets say the field Area was not on the table and only had four fields left.

Re: Activate Button based on selection

bc-thebruuu — Wed, 16 May 2018 13:53:34 GMT

As long as Area is on the script, it doesn't matter if you show it or not.

But let's suppose that you don't have it ... you could even use OriginalTable in this way:

Count(DISTINCT{<OriginalTable=p(OriginalTable),_AreaFlag={">0"}*p(_AreaFlag)>}OriginalTable)>0

and GetSelectedCount(OriginalTable)>0