topic Re: Clear all selection in qlikview in QlikView

Clear all selection in qlikview

deepakqlikview_123 — Tue, 14 Jul 2015 15:23:44 GMT

Hi All,

I am using clear all.on different different sheet.

On one of clear all i have applied alternate state while on other did not applied but when i am using clear all (inherited state), my other default selection on clear having alternate state all is also disappearing.

can you please suggest on this

Re: Clear all selection in qlikview

MK_QSL — Tue, 14 Jul 2015 15:36:38 GMT

Provide sample file...

You can select Alternate State in Action tab also...!!

Re: Clear all selection in qlikview

deepakqlikview_123 — Tue, 14 Jul 2015 17:45:40 GMT

Hi Manish,

PFA.

I have sheet1 and she applied condition as region = all in clear button of sheet 2 so that whenever clear on sheet 2 happens it will directly shows region all but when i can apply clear on sheet 1 in my sheet 2 default selection also disappears moreover when ever i can choose region on sheet 2 region selection appears in current selection box of sheer 1 although there is no region list box.

thanks

Re: Clear all selection in qlikview

deepakqlikview_123 — Wed, 15 Jul 2015 03:54:56 GMT

hi all,

Can you please suggest on this.

Thanks

Re: Clear all selection in qlikview

settu_periasamy — Wed, 15 Jul 2015 04:26:51 GMT

Hi deepak,

Can you tell the steps what would happen if we click the Sheet 1 ClearAll Button and if We click the Sheet 2 Clear All Button?

Re: Clear all selection in qlikview

Wed, 15 Jul 2015 04:59:37 GMT

Hi,

I think it will help u to complete the task

r.click on sheet go to sheet properties

Go to triggers -> there u can see onleave sheet -> click on edit actions -> click on ADD -> under selection -> u can see the clear all -> ok ->ok -> apply -> ok

Hope it will help u.

Thank you,

Balaji.k

Re: Clear all selection in qlikview

deepakqlikview_123 — Wed, 15 Jul 2015 05:00:18 GMT

I am using clear all.on different different sheet.

On second sheet clear all i have applied alternate state while for first sheet did not applied but when i am using clear all (inherited state) for first sheet, my other default selection on clear having alternate state(second sheet) all is also disappearing.on second sheet Region='All' should be default.er clearing moreover region selection should not appear on first sheet's current selection box

Re: Clear all selection in qlikview

deepakqlikview_123 — Wed, 15 Jul 2015 05:05:29 GMT

its not working

Re: Clear all selection in qlikview

settu_periasamy — Wed, 15 Jul 2015 05:09:05 GMT

Hi deepak,

if i understood correctly, Try this

In the first Sheet -> Clear All Button -> Give the Default State.

Re: Clear all selection in qlikview

deepakqlikview_123 — Wed, 15 Jul 2015 05:40:08 GMT

hi settu,

it is already in default state.

thanks

Re: Clear all selection in qlikview

settu_periasamy — Wed, 15 Jul 2015 05:48:27 GMT

When i open your document, Button Properties, Alternative State shows blank.

can you check attached?. It is working for me.

Re: Clear all selection in qlikview

awhitfield — Wed, 15 Jul 2015 10:37:03 GMT

Hi Deepak you has missed off the actual Alternate State on BOTH Clear All Buttons!

HTH - Andy

Re: Clear all selection in qlikview

deepakqlikview_123 — Mon, 20 Jul 2015 13:19:59 GMT

Hi All,

PFA

It is still showing problems, on accesspoint when i am clearing data on other sheet my sheet where i have alternate state is applied is also affected.It is showing no data after that(no data to display)When i am clearing selection on sheet 1 sheet 2 is also getting cleared.

thanks