Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
cocalero
Creator
Creator

Setup Variables into the Script from resident

Hello,

I would like to declare some variables:

Here my script:

Capture.PNG

How can i improve this script ? Do you have some advise for me please ?

Because i find some mistakes into the variables ...

Thank you in advance for your help,

Sébastien.

1 Solution

Accepted Solutions
sunny_talwar

1) I would save the variables as Num instead of dates just because its very easy to convert a numeric value to date on the front end.


2) Secondly may be you can create a list of sources and look through them instead of having to concatenate this multiple times.

3) I don't really think you need Distinct, but having it in there doesn't do any harm.

View solution in original post

5 Replies
sunny_talwar

1) I would save the variables as Num instead of dates just because its very easy to convert a numeric value to date on the front end.


2) Secondly may be you can create a list of sources and look through them instead of having to concatenate this multiple times.

3) I don't really think you need Distinct, but having it in there doesn't do any harm.

View solution in original post

cocalero
Creator
Creator
Author

Thanks you for your help !

sunny_talwar

If you can copy paste your script, I might be able to provide you with an updated script with points 1 and 3. Point 2 which you can try if you really want to, otherwise this would work as well

cocalero
Creator
Creator
Author

Thanks you !

Here my Script (modified):

Variables:

load Distinct Date(MAX(AsOf), 'DD/MM/YYYY') as LastAsOf1

resident [All_Data] where source = 'Projection_CTY';

Let Last_Update_Projection = Date(Peek('LastAsOf1'), 'DD/MM/YYYY');

Concatenate

load Distinct Date(MAX(AsOf), 'DD/MM/YYYY') as LastAsOf2

resident [All_Data] where source = 'Costs_PC';

Let Last_Update_Costs = Date(Peek('LastAsOf2'), 'DD/MM/YYYY');

Concatenate

load Distinct Date(MAX(AsOf), 'DD/MM/YYYY') as LastAsOf3

resident [All_Data] where source = 'Staff_Kert';

Let Last_Update_Staff = Date(Peek('LastAsOf3'), 'DD/MM/YYYY');

Concatenate

load Distinct Date(MAX(AsOf), 'DD/MM/YYYY') as LastAsOf4

resident [All_Data] where source = 'NBI_Data';

Let Last_Update_NBI = Date(Peek('LastAsOf4'), 'DD/MM/YYYY');

Concatenate

load Distinct Date(MAX(AsOf), 'DD/MM/YYYY') as LastAsOf5

resident [All_Data] where source = 'RWA_CTY';

Let Last_Update_RWA = Date(Peek('LastAsOf5'), 'DD/MM/YYYY');

Concatenate

load Distinct Date(MAX(AsOf), 'DD/MM/YYYY') as LastAsOf6

resident [All_Data] where source = 'Budget_NBI';

Let Last_Update_Budget_NBI = Date(Peek('LastAsOf6'), 'DD/MM/YYYY');

sunny_talwar

May be try this:

Variables:

LOAD RowNo() as Key,

          MAX(AsOf) as LastAsOf1

Resident [All_Data]

Where source = 'Projection_CTY';

Join (Variables)

LOAD RowNo() as Key,

          MAX(AsOf) as LastAsOf1

Resident [All_Data]

Where source = 'Costs_PC';

Join (Variables)

LOAD RowNo() as Key,

          MAX(AsOf) as LastAsOf1

Resident [All_Data]

Where source = 'Staff_Kert';

Join (Variables)

LOAD RowNo() as Key,

          MAX(AsOf) as LastAsOf1

Resident [All_Data]

Where source = 'NBI_Data';

Join (Variables)

LOAD RowNo() as Key,

          MAX(AsOf) as LastAsOf1

Resident [All_Data]

Where source = 'RWA_CTY';

Join (Variables)

LOAD RowNo() as Key,

          MAX(AsOf) as LastAsOf1

Resident [All_Data]

Where source = 'Budget_NBI';

LET Last_Update_Projection = Peek('LastAsOf1');

LET Last_Update_Costs = Peek('LastAsOf2');

LET Last_Update_Staff = Peek('LastAsOf3');

LET Last_Update_NBI = Peek('LastAsOf4');

LET Last_Update_RWA = Peek('LastAsOf5');

LET Last_Update_Budget_NBI = Peek('LastAsOf6');