Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kumarkp412
Creator II
Creator II

clear all the selection

Hi friends,

I having two sheets , in each sheet it is having clear buttons ok

In the first sheet , i have used the activation of sheet object ,then it going fine.

when i am clicking the clear buttons, it should clear the current sheet and the sheet should be the current sheet , it should not go to another sheet,(i.e it should clear all the selection in the sheet and it should not go to another Sheet)

I am trying this to do , but when i was trying to clearing the sheet it is clearing the selection and it is going to another page ,

So i want to restrict that , it should not go to another page.

Can any one suggest me solutions  freinds,...

Thanks

Kumar

1 Solution

Accepted Solutions
timanshu
Creator III
Creator III

Yes, the same expression should work.  That is    =If(GetSelectedCount(Date1),'SH02')

Write this expression on Triggers of "On Any Select"->Activate Sheet.

Kindly Find the attached Sample.It's Working.


View solution in original post

16 Replies
jyothish8807
Master II
Master II

Hi Praveen,

I guess you are using any trigger which is taking you to another page, check if any trigger is there or not. If yes then delete the trigger. When you clear it is supposed to be on the current page.

Regards

KC

Best Regards,
KC
morganaaron
Specialist
Specialist

Hi Kumar,

Have you got any sheet activation triggers on your clears? Or any conditions on shows?

If you have different fields/filters on each sheet you could clear just those particular field selections with a clear button, otherwise you'd need an alternate state on each sheet to ensure selections are only cleared on one or the other.

It shouldn't switch sheets unless a condition forces it to.

kumarkp412
Creator II
Creator II
Author

HI Jyothish,

Yes i am using the trigger , if i remove the trigger then how can i go to another page .

my requirement is if,i select any column in the first sheet it should  navigate to another sheet.

So that's i am using the trigger.

Is their any other way to navigate page with out the trigger.

Thanks

Kumar

kumarkp412
Creator II
Creator II
Author

Hi Aarogn,

Thanks for reply,

Yes i am having the sheet activation triggers.

Can you give me small example please..

Thanks

Kumar

morganaaron
Specialist
Specialist

Can you upload an example app?

Where is your sheet activation trigger? Or what determines which sheet you go to?

You can create a textbox/button that has a trigger attached that will clear a particular field or set of fields, unless your trigger is determined by a particular field that you want to clear!

Separately if you want your selections to only affect a particular sheet, have a look at alternate states (settings > document properties > alternate states) as a way to ensure it only affects a particular sheet.

jyothish8807
Master II
Master II

Hi,

In your case the clear all button is linked with triggers, why don't you clear the triggers and use a different button to move to next page, it is inbuilt with in QV.

Regards

KC

Best Regards,
KC
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi Kumar,

Can you post sample file?

And list all the actions you want to perform in order you want it executed

Many thanks

kumarkp412
Creator II
Creator II
Author

Hi ALL,

Here i am attaching sample qvw.

In this ,first sheet if  i select any row or column then it go to the next sheet , is that ok but whent i do  clear the selection by using the button then also it is going to another sheet.

When i do the clear selection , It should not go to another sheet

Is that am i wrong?

Thanks

Kumar

tresesco
MVP
MVP

When you are activating sheet on field selection, write expression like:

    =If(GetSelectedCount(Date1),'SH02')

Similarly for other fields.