Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

always one selected option removing and asigning for listbox

Hi All,

              i have 2 sheets in dashboard in sheet1 quarter field selected as default one option and when i move to next sheet2 the 'always one selected' option is clearing and when coming back to sheet1 'always one selected' option is asigning to listbox by using on sheet active and on sheet leave events in sheet properties, but when i use same functionality for month field in sheet2 it is not working in both sheets ,please suggest me the best way to active this. i used macro in sheet active and sheet leave events.

please give me a solution for this.

16 Replies
Highlighted
Not applicable

Re: always one selected option removing and asigning for listbox

please use buttons concept instead of macro.

try to use sheet actions( on activate and on leave sheet)

Highlighted
Master
Master

Re: always one selected option removing and asigning for listbox

I've just been messing with this and I think its some sort of timing issue... the macro isn't finishing before the clear field or something crazy

I'll keep playing

Highlighted
Master
Master

Re: always one selected option removing and asigning for listbox

How do you change the 'always one selected' without a macro then?

Highlighted
Master
Master

Re: always one selected option removing and asigning for listbox

Yeah it works if you put the month selection in the macro...

Highlighted

Re: always one selected option removing and asigning for listbox

You may need like below. I am done without Macro. In fact, I don't like to use Macros it kills the performance on AJAX Browser

PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Master
Master

Re: always one selected option removing and asigning for listbox

You don't have always one selected value activated.....

Highlighted

Re: always one selected option removing and asigning for listbox

It is there, When you back to SH01 from SH02.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Master
Master

Re: always one selected option removing and asigning for listbox

I can select multiple options

Capture.PNG

Highlighted
Creator III
Creator III

Re: always one selected option removing and asigning for listbox

I have change your macro and now is working

only one think is you need to choose the same time frame (like in example Nov-Q4- you can add one more trigger and change it to Q1)

Anna