How to clear the Always One selected value

[#1]

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

[#2]

Dear D V,

  Thanks for the Answer.

  its correct answer

Thanks & Regards,

Santhosh Kumar G

[IAMDV]

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,

DV

[#4]

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

[IAMDV]

Hi Venkata,

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

Thanks,

DV

www.QlikShare.com

[sibin_jacob]

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

[renjithpl]

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

[renjithpl]

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 !!

[sr_qlikview]

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

[diogopereira89]

Thanks for wonderful answer Deepak Vadithala

[#11]

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