topic Re: triggers in QlikView

triggers

Bubskim — Sun, 28 Jul 2019 17:03:24 GMT

Hi all.

I desperetly need help!

I need to set a trigger so that all of the data on my sheets open for today -1. It is opening all the data but not today -1. The same goes for in the charts I need data to reflect today -1 . i tried to add it as a dimension but no luck.

Re: triggers

fkeuroglian — Mon, 29 Jul 2019 21:45:42 GMT

You can use trigger select in field as today()-1 or max(actual date)-1

See this post to have diferents examples to do this:

https://community.qlik.com/t5/QlikView-App-Development/Trigger-Previous-Day-on-Open/td-p/436932

Hope helps

Fernando

Re: triggers

Bubskim — Wed, 31 Jul 2019 12:30:38 GMT

Hi.

It does not work. I went into the sheet. I chose sheet properties by right clicking on it.

Then triggers on activate

select in field

=today()-1

or = today (-1)

nothing worked after saving and re opening. Still prefills to total vs d-1.

Re: triggers

Brett_Bleess — Tue, 20 Aug 2019 21:21:31 GMT

Kimberly, you will likely get more help if you can attach the application so folks can see the data model and everything. You can scramble any confidential fields in the data model by going to Settings\Document Properties\Scrambling tab in the Desktop Client and choosing the fields to scramble...

Regards,
Brett