topic Re: RE:All should clear in QlikView

RE:All should clear

Chanty4u — Mon, 14 Mar 2016 05:38:29 GMT

Hi all,

I have small issue on my stright table .

i have stright table with triggers and wen i select the value in table[Project] it shud go to next sheet that is very much fine.

but wen i came back to the my table sheet the selection should not be there

i.e it clears all selections?

How to achve?

Thanks in advance.

Re: RE:All should clear

settu_periasamy — Mon, 14 Mar 2016 05:45:25 GMT

Hi,

Do you want Clear All value when you come back in Main Sheet?

May be try with the Trigger OnActivateSheet -> Clear All

Re: RE:All should clear

avinashelite — Mon, 14 Mar 2016 05:46:36 GMT

You could set the trigger on the sheets also , try like this

Go to sheet properties> Tiggers >and set triggers for > select on activate and on sheet leave

Hope this helps you

Re: RE:All should clear

MayilVahanan — Mon, 14 Mar 2016 05:46:52 GMT

Try like this

Sheet properties -> Trigger -> OnActivateSheet -> Clear All

PFA

Or, change the trigger based on your requirement. (ie,. Clear only one field, clear all., etc)

Re: RE:All should clear

jagan — Mon, 14 Mar 2016 05:58:48 GMT

HI,

You can clear all the selections you are back to the sheet using the Sheet Level Triggers like below

Try like this

Sheet properties -> Trigger -> OnActivateSheet -> Clear All

Regards,

jagan.

Re: RE:All should clear

Chanty4u — Mon, 14 Mar 2016 05:59:10 GMT

thnks all,

but i hve four sheets in my original qvw.

so i want in only one sheet values shud be cleared.? how it is psbl?

means: i hve seleted in table and cme bak its clear all no issues.

but wen i made any selection on other sheet and come bak to this sheet here also no selection availbe? so how can i achve this?

Re: RE:All should clear

Chanty4u — Mon, 14 Mar 2016 06:00:04 GMT

yeah jagan. but i need only perticular sheet only ... but its making clear to all selection in other sheets also.

Re: RE:All should clear

MayilVahanan — Mon, 14 Mar 2016 06:04:44 GMT

Hi,

Could you please say your requirement with example. its little bit confusing..

If you clear one field value in any sheet, its reflect in whole dashboard.

Re: RE:All should clear

Chanty4u — Mon, 14 Mar 2016 06:07:07 GMT

Hi mayil,

Thanks

PFA ..

yeah dat is wat i dnt want....onle one sheet values shud be clear all?

Re: RE:All should clear

jagan — Mon, 14 Mar 2016 06:08:37 GMT

Filter objects are not restricted to a sheet, it is across a Dashboard level the selections carries across all sheets, if you clear in one sheet it will clear in all sheets.

The workaround for this is create new field from the existing field like below

LOAD

Field1 AS Field2

FROM DataSource;

Now use this field in your sheet and clear it when you are coming to the sheet instead of clearing all the selections.

Regards,

jagan.

Re: RE:All should clear

Chanty4u — Mon, 14 Mar 2016 06:12:35 GMT

if i create field1 as filed2

which trigger i need to use in sheet?

Re: RE:All should clear

jagan — Mon, 14 Mar 2016 06:14:28 GMT

HI,

Use the new field in table, field event trigger and clear this field in sheet trigger.

Regard,s

Jagna.

Re: RE:All should clear

Chanty4u — Mon, 14 Mar 2016 06:19:33 GMT

no jagan its not wrkng?

abve i attached updated qvw wit alrdy created new field

can u do on that?

Re: RE:All should clear

jagan — Mon, 14 Mar 2016 06:33:40 GMT

Hi,

Try this

Regards,

Jagan.

Re: RE:All should clear

Chanty4u — Mon, 14 Mar 2016 06:34:43 GMT

missing the attachmnt jagan

Re: RE:All should clear

sasikanth — Mon, 14 Mar 2016 06:45:23 GMT

Hi,

There are two cases here

1) if it single field and if you are selecting that field then can manage with triggers

2) it will fail in remaining all scenarios

Please tell us your original requirement so that we can find any alternate solution for this

Re: RE:All should clear

Chanty4u — Mon, 14 Mar 2016 06:46:47 GMT

only that table selections shud be clear wen i cme bak from other sheet.

Re: RE:All should clear

jagan — Mon, 14 Mar 2016 06:47:00 GMT

PFA.

Regards,

jagan.

Re: RE:All should clear

MayilVahanan — Mon, 14 Mar 2016 06:51:40 GMT

Instead of clear all, use clear field trigger in "Sheet Properties" -On Activate sheet.

Hope it helps