topic Re: clear in QlikView

clear

manoranjan_d — Tue, 17 Mar 2015 11:21:35 GMT

Hi,

When ever i click the clear button , it should select some default selection.

Example when i click the clear button, correct selection should be in default selection of DEPT "IT" COLLAGE "AMIT".

please help me..

Re: clear

manoranjan_d — Tue, 17 Mar 2015 11:22:29 GMT

current selection shd be in default selection of DEPT "IT" COLLAGE "AMIT".

Re: clear

manoranjan_d — Tue, 17 Mar 2015 11:47:29 GMT

no replies

Re: clear

hic — Tue, 17 Mar 2015 12:01:48 GMT

Make the selection first, then set this as "Clear State".

HIC

Re: clear

manoranjan_d — Tue, 17 Mar 2015 12:10:07 GMT

@ Henric .we need the clear state but filters may differs from sheet by sheet.

Re: clear

manoranjan_d — Tue, 17 Mar 2015 12:11:48 GMT

example.

in sheet1 if i select clear button it shd be in DEPT "IT" COLLAGE "AMIT".

in sheet2 if i select clear button it shd be in DEPT "COMP" COLLAGE "MIT".

in sheet3 if i select clear button it shd be in DEPT "ROBO" COLLAGE "ANNA".

Re: clear

manoranjan_d — Tue, 17 Mar 2015 12:12:25 GMT

@henric above is the example.

Re: clear

buzzy996 — Tue, 17 Mar 2015 12:17:05 GMT

i think so it's not possible dirctly,

what i suggest here, create on button with Clear all (that helps to clear all ur current selections by using default ClearAll macro) and top of that button trigger another macro to perform ur default selections.

ask ur users to use this button.

Re: clear

hic — Tue, 17 Mar 2015 12:17:23 GMT

Then you need to make a button with an Action or a Macro.

HIC

Re: clear

manoranjan_d — Tue, 17 Mar 2015 12:20:52 GMT

i have to add those functions in default clear button . not in the creattion of new button

Re: clear

manoranjan_d — Tue, 17 Mar 2015 12:21:41 GMT

@shiva its possible we can do it...

Re: clear

hic — Tue, 17 Mar 2015 12:22:06 GMT

Not possible.

HIC

Re: clear

Colin-Albert — Tue, 17 Mar 2015 12:23:26 GMT

Use bookmarks, or an action to Clear All and then set the required value in the Dept field.

Re: clear

manoranjan_d — Tue, 17 Mar 2015 12:23:38 GMT

No Henric, we can do it, its possible..

Re: clear

buzzy996 — Tue, 17 Mar 2015 12:26:38 GMT

pls let me know if possible

Re: clear

robert_mika — Tue, 17 Mar 2015 12:26:53 GMT

This is getting interesting....

Re: clear

jonathandienst — Tue, 17 Mar 2015 12:45:54 GMT

You may just be able to do it with a macro - there is an API call: Document.SetClearState

To implement what the OP is after, you would need a bookmark for each tab, on OnActivate Sheet, the macro would apply the bookmark for that tab, and then call Document.SetClearState.... -- assuming that API call works in all environments.

Not a solution I like, but then I generally avoid macros, and our environment is pure Ajax....

Jonathan

Re: clear

Peter_Cammaert — Tue, 17 Mar 2015 13:53:10 GMT

No it's not.

You may create a workaround that does (more or less) what you want, but you cannot let the Clear button trigger an action.

It gets even better: the Clear button will clear list box selections but the list boxes won't recognize this as a change in selections per se and therefore won't trigger any OnSelect/On Change/OnAnySelect actions. Doh.

Re: clear

edi — Tue, 17 Mar 2015 13:57:06 GMT

As a workaround, you can use a bookmark with your default state. And have a button activate the bookmark to restore your state, when they want to go back to it.