topic Re: Document Trigger Requirement in QlikView

Document Trigger Requirement

kkkumar82 — Fri, 29 May 2015 10:28:16 GMT

Hi all,

I have a dashboard with year, Quarter etc filters. The dashboard should open with by default the selection on the field year with current year value i.e. 2015.

For this I created a document trigger "on open " where I extracted year from today() and assigned to the field year.

Another requirement is if the user clicks clear then once again year filter should be selected with 2015.

I tried with "once change" trigger on field trigger "year" but unsuccessful.

Thanks

Kiran Kumar

Re: Document Trigger Requirement

awhitfield — Fri, 29 May 2015 10:35:22 GMT

HI Kiran,

you could create a custom 'CLEAR' button, which clears all selections and then reselects 2015 in the year field, see attached:

Re: Document Trigger Requirement

Fri, 29 May 2015 10:42:57 GMT

Hi Kiran,

Check if this worksout for you. Created a dummy variable and have set a trigger on change for selecting current year.

Re: Document Trigger Requirement

kkkumar82 — Fri, 29 May 2015 11:03:59 GMT

Thanks all,

I cannot have a button for this because we are using div integration of these charts into a web application and from UI side we are using a button which uses java script API for clearing, sandeep how the variable is used because I didnt see any value getting into it.

Thanks

Kiran Kumar

Re: Document Trigger Requirement

martin_dideriks — Fri, 29 May 2015 11:12:51 GMT

What about "Set clear state"? That would "reset" your selections.

//Martin

Re: Document Trigger Requirement

kkkumar82 — Fri, 29 May 2015 11:23:14 GMT

Where is this action ??

Re: Document Trigger Requirement

kkkumar82 — Fri, 29 May 2015 11:25:58 GMT

Hi all,

I am trying for a solution which I want to try with the clear option in Qlikview Desktop not with a button and seeing if there are any triggers in this case.

Thanks

Kiran Kumar

Re: Document Trigger Requirement

Fri, 29 May 2015 11:34:16 GMT

Hi Kiran,

There seems to be a bug when clear is made which activates the trigger. This seems to work for your requirement.

Tried assigning a value to the variable in addition to select year value, unable to make it work. Will try on that.

This post may help you

Trigger on clear?

Another way is to set clear state,but need to know a way of setting dynamic clear state(in your case latest year). Its on the clear button, but not as an action.

Thanks,

Sandeep

Re: Document Trigger Requirement

antoniotiman — Fri, 29 May 2015 11:36:40 GMT

Hi Kiran,

in Document Property,trigger,field,modify You add

=If(GetSelectedCount(Year)=0,$(=Year(Today())))

Regards,

Antonio

Re: Document Trigger Requirement

kkkumar82 — Fri, 29 May 2015 13:59:03 GMT

I got it , but I have a doubt about security using macros in integration.

Is there a real problem using macros in Qlikview desktop or Access point or Integration, I have to know , to use this solution.

Thanks all for ur immediate suggestions

Re: Document Trigger Requirement

awhitfield — Fri, 29 May 2015 14:01:43 GMT

Bear in mind MACROS only work with the IE Plugin and even then, not all of them!! GOOD LUCK

Andy

Re: Document Trigger Requirement

mishraamit2485 — Sat, 31 Oct 2015 05:56:54 GMT

Hi Kiran, I'm in similar situation as your, clear should trigger the latest quarter.

Did you get any solution for this? Please help.