topic Re: How to clear the Always One selected value in QlikView

How to clear the Always One selected value

Sun, 02 Oct 2011 08:14:36 GMT

Dear All,

My problem is i have given the "Always One Selected value" in List Box Propeties.When i will go to the next sheet i need to clear all the selections whatever i have made in the sheet.

I have given the trigger Clear All in On Activate sheet,except that List Box all selection are made clear.

is there any possibility to do it.

Regards,

Santhosh

How to clear the Always One selected value

jonathandienst — Sun, 02 Oct 2011 09:26:43 GMT

Santhosh

Clear All does not work if you have always one selected enabled. The only way to clear all is to first remove the Always one selected property using a macro. I don't have a script for this but I have seen it on this forum before.

Regards

Jonathan

Re: How to clear the Always One selected value

its_anandrjs — Sun, 02 Oct 2011 10:30:52 GMT

Hi Santosh,

If you use differently all is ok in place of "Always One Selected value" in List Box Propeties just remove this setting and try to put a Button to select always on value there like add a propertey on button "Select in Field" -> Then select Field -> and select Search String just click a button once it will automatically select one value in your list box. And when you go to next sheet use trigger or clear all fuctionallity.

See the attached sample file.

HTH

Rgds

Anand

How to clear the Always One selected value

Sun, 02 Oct 2011 10:32:05 GMT

Hi Anand,

But my Constraint is i don't want to allow to select morethan one value in Field.

Thanks & Regards

Santhosh Kumar

How to clear the Always One selected value

swuehl — Sun, 02 Oct 2011 11:23:45 GMT

Hi,

I think you could use following to achieve what I think you want:

Go to document properties --> triggers. In field event triggers, select your field you want to limit selection for.

Add an OnSelect action, action type is Select - Select in field.

Then enter your field name in the appropriate field entry box:

YOURFIELD

(just the name, no equal sign etc.).

as search expression use

=subfield(GetFieldSelections(YOURFIELD),',')

This should limit the selection to up to one value, but still allowing to clear the list box.

(tested on QlikView V10 SR3)

Regards,

Stefan

How to clear the Always One selected value

Sun, 02 Oct 2011 11:37:34 GMT

Hi Stefen,

Can i have any example application on this.it would be help full for me.

Thanks & Regards

Santhosh Kumar G

Re: How to clear the Always One selected value

swuehl — Sun, 02 Oct 2011 11:54:21 GMT

Hi,

see attached.

Please note that clearing the field will lead to all values are in possible selection state, which is probably not what your requirement says.

Maybe you could work around this by applying a calculation condition to your objects, like =GetSelectedCount(YOURFIELD)>0

How to clear the Always One selected value

IAMDV — Sun, 02 Oct 2011 21:59:58 GMT

Hi Santosh,

I have written the VB script for this functionality. I had exactly similar problem of restricting user to one selection yet making sure it works even you toggle to different sheets. I have this script in my work laptop and I can share it tomorrow morning. BTW - It is 10:58pm on Sunday night. I hope its okay with you.

Cheers - DV

Re: How to clear the Always One selected value

swuehl — Sun, 02 Oct 2011 22:54:35 GMT

Hi Santhosh Kumar G,

seems I missed your request to clear all on changing to another sheet. But as you said, you could do this with another trigger and action on OnActivateSheet.

I still think your requirement to clear all on changing to another sheet and having a always one selected state is somewhat contrary. What do you do if someone changes back to the sheet with the alway one selected value field?

Regards,

Stefan

edit: Just in case you want to restore your orginal - but then cleared - selection in your field when returning to that sheet, I think you could do this with just two more actions triggered by OnActivateSheet and OnLeaveSheet, where you set / read back the selection to / from a variable.

See attached V2 of the sample.

Re: How to clear the Always One selected value

IAMDV — Tue, 04 Oct 2011 10:26:13 GMT

Hi Santosh,

Sorry for not getting back yesterday. I have quickly mocked an example from Swuehl's QV file. I have used two Sub Procedures... one to enable the AlwaysSelectedOne and another to disable. I have called these two procedures on Sheet Properties Triggers, I have used the AlwaysOneSelected Procedure on Sheet Activate and before that event I have added one more event which selects a default value. In our case, I have used India as the default but you may set anything or best thing is to capture the last selection of the user of the field in the variable and use the variable to recall the last selection in the trigger. And I have used RemoveAlwaysOneSelected procedure OnDeactiveSheet event.

Here are the VB Script Procedures :

Sub AlwaysOneSelected

set obj = ActiveDocument.GetSheetObject("LB02")

set boxfield=obj.GetField

set fprop = boxfield.GetProperties

fprop.OneAndOnlyOne = True

boxfield.SetProperties fprop

End Sub

Sub RemoveAlwaysOneSelected

set obj = ActiveDocument.GetSheetObject("LB02")

set boxfield=obj.GetField

set fprop = boxfield.GetProperties

fprop.OneAndOnlyOne = False

boxfield.SetProperties fprop

ActiveDocument.ClearAll True

End Sub

I hope this makes sense and hope it helps to meet your requirement.

Cheers - DV

How to clear the Always One selected value

Fri, 30 Dec 2011 04:17:48 GMT

Dear D V,

Thanks for the Answer.

its correct answer

Thanks & Regards,

Santhosh Kumar G

Re: How to clear the Always One selected value

IAMDV — Fri, 30 Dec 2011 17:06:17 GMT

Hi Santhosh,

Please can you mark the relevant answer correct if this is what you needed. This helps other users as well.

I have made a video post on this topic. Please check QlikShare.Com for detailed step-by-step demonstration.

Happy learning.

Thanks,

Re: How to clear the Always One selected value

Thu, 21 Jun 2012 18:14:28 GMT

Hi Guys,

The above code is working fine in QV developer. But when i deploy it on the server and opened

the application through IE client, the macro not able to set the property or reset the property onlyoneselected.

Can someone shed some light on this why this not working in client? I badly need this to be working...

Thanks in advance.

Regards,

Venkata

Re: How to clear the Always One selected value

IAMDV — Thu, 12 Jul 2012 10:07:44 GMT

Hi Venkata,

Is the macro enabled? I've tried in my environment and it works fine.

Thanks,

www.QlikShare.com

Re: How to clear the Always One selected value

sibin_jacob — Fri, 27 Jul 2012 15:09:10 GMT

HI Santhosh,

First you untick always one selected value in list box.

Then goto Document properties -> Triggers tab ->

OnAnySelect -> Add one action ->

Select in field -> you may give your field name ->

In search string ->

=if((GetSelectedCount(Field1)=0 or GetSelectedCount(Field1)>1) and

GetActiveSheetId()='Document\SH01',[your default value],GetFieldSelections(Field1)

Thanks

Sibin

Re: How to clear the Always One selected value

renjithpl — Sun, 11 Nov 2012 08:03:23 GMT

In reply to sibin,

i want the exact code like

=if((GetSelectedCount(Field1)=0 or GetSelectedCount(Field1)>1) and

GetActiveSheetId()='Document\SH01',[your default value],GetFieldSelections(Field1)

but the above code will work only for one sheetid,

what should i add, if i want it work on all the sheets or more than one sheet.

any idea ?

regards

Ranjit

Re: How to clear the Always One selected value

renjithpl — Sun, 11 Nov 2012 08:20:05 GMT

I got it right,

if((GetSelectedCount(CalDate)=0 or
GetSelectedCount(CalDate)>1) and
(GetActiveSheetId()='Document\SH25' or
GetActiveSheetId()='Document\SH23' or
GetActiveSheetId()='Document\SH07' Or
GetActiveSheetId()='Document\SH05' or
GetActiveSheetId()='Document\SH11'),
date(max({$1}CalDate), 'M/D/YYYY'),
GetFieldSelections(CalDate

))

this post is a one useful,

thank you all !!

Re: How to clear the Always One selected value

sr_qlikview — Fri, 19 Apr 2013 16:11:38 GMT

DV -- this is exactly what i am looking for ..great work.

Re: How to clear the Always One selected value

diogopereira89 — Thu, 02 Jan 2014 17:28:00 GMT

Thanks for wonderful answer Deepak Vadithala

Re: How to clear the Always One selected value

Wed, 26 Nov 2014 07:24:47 GMT

you can use Alternate States So that it will not having any effect on Other Sheets or Objects...