Problem creating a Variable from Load Script

Anonymous — Tue, 05 Jun 2018 14:16:17 GMT

He Everyone

I'm new to QlikView and I am struggling with variables, I've the following Script

Script
LastQtrNR: Load (Max(Num(Mid(Trim([Period]),3,2))+ (Num(Right(Trim([Period]),1))/10))) As [MaxQtr] From [..\QlikView\DataSource.qvd](qvd) Where [Metric] <> 0 ; Let vLastQtr = Num(Peek('[MaxQtr]',1)); Drop Table LastQtrNR; T: Load '$(vLastQtr)' As MaxQuarter;

Script

LastQtrNR:

Load

(Max(Num(Mid(Trim([Period]),3,2))+ (Num(Right(Trim([Period]),1))/10))) As [MaxQtr]

From [..\QlikView\DataSource.qvd](qvd)

Where [Metric] <> 0

;

Let vLastQtr = Num(Peek('[MaxQtr]',1));

Drop Table LastQtrNR;

Load '$(vLastQtr)' As MaxQuarter;

Thing is the result of the first load statement should be "18.1" Which I will convert in FY18 Q1, and store it in vLastQtr, however, I'm not able to verify the result of the variable assignation with the load, and I'm not sure on how to modify the variable value to use it as a filter for other queries

Re: Problem creating a Variable from Load Script

Miguel_Angel_Baeyens — Tue, 05 Jun 2018 15:09:00 GMT

Once you reload the app, you can either create an input box object and add the variable vLastQtr or press Ctrl + Alt + v and see the content of the variable.

You can also add in your script a TRACE function to display in the loading screen the value of the variable:

Let vLastQtr = Num(Peek('[MaxQtr]',1));

TRACE --> $(vLastQtr);

Drop Table LastQtrNR;

[...]

topic Re: Problem creating a Variable from Load Script in QlikView

Problem creating a Variable from Load Script

Re: Problem creating a Variable from Load Script