QlikView App: Using Actions To Change Date Variables

stevedark — Wed, 29 May 2013 21:49:04 GMT

This QlikView shows how buttons can be used to increment or decrement date variables.

Where expressions call for comparisons to dates these can often be looked up from a date table. Better performance and improved manageability can be obtained by comparing to dates stored in a variable. Variables can be updated from data in the model or via triggers, but I find a better approach is to use buttons and actions.

The QlikView was originally written as a response to the following QlikCommunity thread http://community.qlik.com/message/130380

Further examples of using Actions can be found in this blog post and Video: http://bit.ly/15PEpQ9

Steve Dark

www.quickintelligence.co.uk

Re: QlikView App: Using Actions To Change Date Variables

stevedark — Thu, 27 Mar 2014 07:25:29 GMT

Just seen a nice date selection widget by rebeccad which uses a show / hide condition to only bring up the date selector when it's needed:

intuiQlik | User-Friendly Date Range Selection

There's a nice example of a gantt chart on this post also.

article QlikView App: Using Actions To Change Date Variables in Member Articles

QlikView App: Using Actions To Change Date Variables

Re: QlikView App: Using Actions To Change Date Variables