Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Using INLINE Statement to manage variables

beeaj2011
New Contributor III

Using INLINE Statement to manage variables

Hi

for a project we are using a significant amout of varibles most of them related to a timestamp.

To manage al possible outcomes and get insight in al the exceptions used we introduced the INLINE Statement to put al values into a table.

With the values of the time stamp used to fill in some fields a good insight into the values and depencies has been realised.

Here's an example(simplified):


let vToday = today() -1;
let vYear = year ($(vToday));
let vPrevYear = $(vYear) - 1;
let vtmpStartDate = date(monthstart($(vToday))); // for extraction Daily Sales

 
load * inline [

var_name, var_formula, var_value, var_comment, var_usage

vToday,"today()-1",'$(vToday)',"current date deffered by 1"
vYear,"(vYear)",'$(vYear)',""
vtmpStartDate,"date(monthstart((vToday)))" ,'$(vtmpStartDate)',"// for extraction Daily Sales "
vPrevYear,"(vYear) - 1",'$(vPrevYear)',""

];
 


Labels (1)
Attachments
Comments
Not applicable

This is amazing. I was trying for the same thing and this article saved me!

Not applicable

This is amazing. I was trying for the same thing and this article saved me!

Version history
Revision #:
1 of 1
Last update:
‎09-24-2012 10:33 AM
Updated by: