topic Re: How can I retain the previous selection among different Buttons in QlikView

How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 04:19:39 GMT

Hi QV,

In my sheet I have 4 buttons.

When I navigate from one button to another, the selections in previous button are not reflecting to current button selection.

So, my requirement is to have previous selections should not be cleared when i navigate among the buttons.

Thanks in Advance,

Ananth

Re: How can I retain the previous selection among different Buttons

amit_saini — Thu, 12 Jun 2014 04:45:28 GMT

Hi Ananth,

You can lock your selections while switching buttons.

Thanks,

Re: How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 04:49:02 GMT

Thanks Amit, but a user can't do it right

Re: How can I retain the previous selection among different Buttons

amit_saini — Thu, 12 Jun 2014 04:55:21 GMT

Hi Ananth,

User can do this . Please see below when I'm looking at my report on access point I can see Lock and Unlock Options

Thanks,

Re: How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 05:07:27 GMT

Thanks for your response Amit,

If we do like this, we need to explain this thing to user.

Can't we have a permanent solution for this.

Re: How can I retain the previous selection among different Buttons

amit_saini — Thu, 12 Jun 2014 05:12:27 GMT

Ananth,

If all those selections you want to lock and are applicable to all the users than plz lock them on your admin application and run the report through QMC , now every user will get that selection by default as locked one's .

Thanks,
AS

Re: How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 05:20:38 GMT

Thanks Amit,

One more Issue,

In a list box how can I select only one value at a time. I don't want to use Always one selected value.

Thanks,

Ananth

Re: How can I retain the previous selection among different Buttons

amit_saini — Thu, 12 Jun 2014 05:26:40 GMT

Ananth, could you please explain a bit more here. You mean to say a user can only select one value in list box not multiple at one time?

Thanks,

Re: How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 05:29:21 GMT

Yes exactly, at a time a user can able to select only one value from the list box, multiple selections should be avoided

Re: How can I retain the previous selection among different Buttons

sasikanth — Thu, 12 Jun 2014 05:31:12 GMT

Hi ananth

For a list box to select list box one value at atime

you need t fire the trigger , onActivateSheet--->Add-->Select in filld-->give the Filed and the value

Then when ever you select the sheet i will automatically select the value in List box

Thanks

Sasi

Re: How can I retain the previous selection among different Buttons

amit_saini — Thu, 12 Jun 2014 05:35:36 GMT

Goto list box properties --> General--> Enable "Always one Selected Value" option the way I did below. This will allow one value at one time.

Thanks,

Re: How can I retain the previous selection among different Buttons

SergeyMak — Thu, 12 Jun 2014 05:38:02 GMT

I think to avoid multiple selection you can use Calculation Condition for your charts like

GetSelectedCount(YourField_In_ListBox)=1

and add Error message for Calculation condition unfulfilled =

Please select only one YourField_In_ListBox

It could be enough

Re: How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 06:03:15 GMT

If I do like above, when I click on CLEAR button the selection in list box is not getting cleared. But what I need is that should be cleared when I click on Clear.

Re: How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 06:07:17 GMT

Thanks for your response Sergey, it is somewhat helpful for me, but here the problem is, I am displaying multiple charts conditionally. If I do like as u told, then other charts get displayed(charts are overlapping based on conditions).

Re: How can I retain the previous selection among different Buttons

SergeyMak — Thu, 12 Jun 2014 06:13:00 GMT

But it's different options

Calculation condition on the General tab of Chart properties and Show Conditional on the Layout tab.

Unfortunately the requirements are not clear for me at the moment.

If you share the app I can try to help you.

Re: How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 06:21:11 GMT

Thanks, but I can't share my App, it has lots of issues.

My requirement is just restrict the list box selection to only one value. User could not select multiple values at time.

Re: How can I retain the previous selection among different Buttons

sasikanth — Thu, 12 Jun 2014 06:30:35 GMT

PFA

Attached File

Re: How can I retain the previous selection among different Buttons

Thu, 12 Jun 2014 06:44:54 GMT

Hi Sasi, Currently i'm using personal edition, so if possible can you post the steps.

Thanks,

Ananth

Re: How can I retain the previous selection among different Buttons

SergeyMak — Thu, 12 Jun 2014 06:50:19 GMT

Nice idea by sasikanth_Narne

Re: How can I retain the previous selection among different Buttons

sasikanth — Thu, 12 Jun 2014 06:53:49 GMT

Hi Ananth

For this you need use triggers

Got to Document properties , FiledEvent triggers --> Add-->Select in Filed -->

<Filed Name> , in Value box Write the condition like

"If(GetSelectedCount(Year)>1,0, GetFieldSelections(Year)) "-->ok

Follow the Procedure ,

Thanks

Sasi