topic Re: clear all the selection in QlikView

clear all the selection

kumarkp412 — Wed, 18 Feb 2015 15:28:39 GMT

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

Re: clear all the selection

jyothish8807 — Wed, 18 Feb 2015 15:34:50 GMT

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

Re: clear all the selection

morganaaron — Wed, 18 Feb 2015 15:36:58 GMT

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.

Re: clear all the selection

kumarkp412 — Wed, 18 Feb 2015 15:40:59 GMT

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

Re: clear all the selection

kumarkp412 — Wed, 18 Feb 2015 15:43:47 GMT

Hi Aarogn,

Thanks for reply,

Yes i am having the sheet activation triggers.

Can you give me small example please..

Thanks

Kumar

Re: clear all the selection

morganaaron — Wed, 18 Feb 2015 15:56:27 GMT

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.

Re: clear all the selection

jyothish8807 — Wed, 18 Feb 2015 16:02:00 GMT

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

Re: clear all the selection

Gabriel — Wed, 18 Feb 2015 16:24:25 GMT

Hi Kumar,

Can you post sample file?

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

Many thanks

Re: clear all the selection

kumarkp412 — Thu, 19 Feb 2015 05:36:29 GMT

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

Re: clear all the selection

tresB — Thu, 19 Feb 2015 06:04:20 GMT

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

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

Similarly for other fields.

Re: clear all the selection

timanshu — Thu, 19 Feb 2015 07:05:11 GMT

Tresesco Is right, On 'Clear' button give action to activate sheet and write " =If(GetSelectedCount(Date1),'SH02')" , then only if any selection to Date1 is made, mentioned sheet is activated.

Re: clear all the selection

kumarkp412 — Thu, 19 Feb 2015 07:23:56 GMT

Hi Tresesco,

Thanks for reply,

I have tried to use this expression ,but it is giving the same result ,

Can you give me small example..

Thanks

Kumar

Re: clear all the selection

sujeetsingh — Thu, 19 Feb 2015 08:41:53 GMT

I think you need to fire this trigger based on two condition one Getactive sheetID and then get selected field.

Re: clear all the selection

timanshu — Thu, 19 Feb 2015 08:50:55 GMT

Hi Praveen

Can you Clear the purpose, two clear buttons on two sheets works same or differently.

Kindly Explain the issue?

Re: clear all the selection

kumarkp412 — Thu, 19 Feb 2015 09:33:06 GMT

Hi Timanshu,

I will explain what i am doing is,

I am having two clear buttons in the two sheets ok.

I am also applying the activation of sheets (i.e if i select any field in the sheet1 and it should be go sheet2 and it show the values based on the selection ) that is ok,

The problem is , when i clear the selection by using the clear button in sheet1 it is clearing all .and it going to sheet 2

It is should not go to the sheet 2,How?

Thanks

Kumar

Re: clear all the selection

timanshu — Thu, 19 Feb 2015 10:37:05 GMT

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.

Re: clear all the selection

kumarkp412 — Thu, 19 Feb 2015 11:26:26 GMT

Hi Timanshu,

The expression is working , Thank you for your explanation

Thanks

Kumar