topic Re: Set variable when clearing selections in QlikView

Set variable when clearing selections

hopkinsc — Wed, 22 May 2013 08:43:01 GMT

Hi,

I was wondering if there is a way to change a variable when the CLEAR button is clicked?

I have some date buttons that change colour when selected. they are blue but when one is clicked it changes to red (just so the user can see which date selection is active). When i clear selections the button still stays red.

Can anyone help me please?

Thanks

Re: Set variable when clearing selections

marcus_sommer — Wed, 22 May 2013 08:52:49 GMT

You can request your selections in variables e.g. with GetFieldSelections(), GetSelectedCount() or GetCurrentSelections().

- Marcus

Re: Set variable when clearing selections

hopkinsc — Wed, 22 May 2013 09:02:50 GMT

Hi Marcus,

Thanks for your reply, but i don't know what you mean..

I want to change a variable value when the clear selections button is clicked.

If a user selects the 'Month to Date' button, this changes a vDateSelection variable to MTD which then turns the button RED.

When the clear selections button is clicked the variable obviously still reads MTD which means the button is still red.

I want to remove the MTD value from the variable.

Does that make sense?

Re: Set variable when clearing selections

flipside — Wed, 22 May 2013 09:07:20 GMT

You can use a Document Event Trigger (OnAnySelect) and add a Set Variable action for a variable with the following value ...

=if(IsNull(GetCurrentSelections()),'',1)

flipside

Re: Set variable when clearing selections

hopkinsc — Wed, 22 May 2013 09:15:14 GMT

Hi Flipside,

Thanks thats what i wanted, the only thing is...

I always have a selection on a field called (BranchView), how would i add this to the formula you gave.

So the current selections will never be empty, there will always be a vlue in 'BranchView'

thanks

Re: Set variable when clearing selections

marcus_sommer — Wed, 22 May 2013 09:22:16 GMT

If you want not clear all fields, you can use GetFieldSelections() or GetSelectedCount() - probably in combines - in the way how flipside suggested.

- Marcus

Re: Set variable when clearing selections

flipside — Wed, 22 May 2013 09:42:04 GMT

This might work (based in this case on a field called 'Region') ...

=if(

Trim(Replace('Region: ' & GetFieldSelections(Region),GetCurrentSelections(),''))='','',1)

... or if the field can be unselected you might need ...

=if(

Trim(Replace(Replace('Region: ' & GetFieldSelections(Region),GetCurrentSelections(),''),'Region:',''))='','',1)

flipside

Re: Set variable when clearing selections

hopkinsc — Wed, 22 May 2013 09:50:11 GMT

hi Flipside,

i have tried this ..

=if(

Trim(Replace('BranchView: ' & GetFieldSelections(BranchView),GetCurrentSelections(),''))='','',1)

but it doesnt seem to work unless all selections are cleared.

do you have any ideas?

Re: Set variable when clearing selections

marcus_sommer — Wed, 22 May 2013 10:03:57 GMT

Put the formula in a textbox and look on the result - perhaps any sign is left (CRLF).

Re: Set variable when clearing selections

flipside — Wed, 22 May 2013 10:05:14 GMT

Hmm, bit of a tricky one - have you got anything else setting the same variable based on selections?

Re: Set variable when clearing selections

hopkinsc — Wed, 22 May 2013 10:15:26 GMT

no, the only thing that set the variable are 5 date button. but obviously when clearing the selections these dates are cleared also (which is correct). nothing else sets the variable value.

it works perfectly if i remove the BranchView selection, but i need this selected always.

Re: Set variable when clearing selections

flipside — Wed, 22 May 2013 10:18:01 GMT

Try this ...

=if(

Trim(Replace('BranchView: ' & GetFieldSelections(BranchView),GetCurrentSelections(),''))='','')

Or perhaps if you can upload an example, maybe there's a better way!

flipside

Re: Set variable when clearing selections

hopkinsc — Wed, 22 May 2013 10:44:19 GMT

hi flipside,

I have attached a quick sample..

i have set a clear state so when clear is clicked it selects 'BranchView = Branch'

there is a variable called vDateRange

the buttons set the variable and make a date selection, and the button colours are calculated based on the variable value.

Any more help would be greatly appreciated

Re: Set variable when clearing selections

flipside — Wed, 22 May 2013 11:11:35 GMT

Must be the Clear State causing it to do this - I have never used this option!

Not sure of a way around it at the moment, but if I think of something I'll post a reply.

Re: Set variable when clearing selections

flipside — Wed, 22 May 2013 13:36:25 GMT

OK, forget the triggers - too complicated. try these expressions for your button colours ...

=if(vDateRange='YTD' and not(Trim(Replace(Replace('BranchView: ' & GetFieldSelections(BranchView),GetCurrentSelections(),''),'BranchView:',''))=''),RGB(255,0,0), RGB(0,0,255))

=if(vDateRange='MTD' and not(Trim(Replace(Replace('BranchView: ' & GetFieldSelections(BranchView),GetCurrentSelections(),''),'BranchView:',''))=''),RGB(255,0,0), RGB(0,0,255))

flipside

Re: Set variable when clearing selections

hopkinsc — Fri, 24 May 2013 15:17:33 GMT

Hi,

I actually got this working by resetting the clear state, adding a list box for the BranchView field, then in the properties of that list box i ticked 'Always one Selected Value'. Deleted the list box.

That gave the same result as using the 'Set Clear State' option.

Then i used your solution above..

=if(

Trim(Replace('Region: ' & GetFieldSelections(Region),GetCurrentSelections(),''))='','',1)

Which did the trick

Thanks for your help!