topic Define variables outside of Load statement in QlikView

Define variables outside of Load statement

Mon, 08 Jul 2013 11:14:51 GMT

Dear All,

i'm looking for a way to define a variable in the script editor, outside of the load statement. To give some context info: in my current qv report, i load sales data from three different excel files;

for the field 'Date', i would like to define a variable called 'maxdate', calculating the most recent date of all my data, to immediately show the last day's numbers on my dashboard screen.

how would you do this?

thank you,

joris

Re: Define variables outside of Load statement

sushil353 — Mon, 08 Jul 2013 11:21:55 GMT

use max(datefield)

Re: Define variables outside of Load statement

rajni_batra — Mon, 08 Jul 2013 11:22:26 GMT

Load Only date field from all ur excels and concate them, then take resident of that and calculate max(date) as Date and then use peek function to store that into a variable.

Transactions:
LOAD
[Date] as [Posting Date]
FROM

(qvd);

concatenate

LOAD
DATE as [Posting Date]
FROM

(qvd);

Temp:
Load
min([Posting Date]) as minDate,
max([Posting Date]) as maxDate
Resident Transactions;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

Re: Define variables outside of Load statement

m_woolf — Mon, 08 Jul 2013 11:27:31 GMT

Create the variable in Variable Overview

Define the variable as:

=max(YourDateField)

Re: Define variables outside of Load statement

Mon, 08 Jul 2013 11:33:57 GMT

Thank you,

it works