Script problem

Sun, 11 Mar 2012 08:27:25 GMT

How to Map the 2 dates column to one column of the master calendar??????

How to assgn the aggregated value of the column to the variable???????

Script problem

erichshiino — Mon, 12 Mar 2012 01:15:41 GMT

Hi, Manish05

You can read your original table twice renaming the different date fields to the same date that you are going to use on your master calendar. Then, you can add a flag to identify each one of your original dates.

In the example below I combined Date1 and Date2 in the same field Date and used FactType as a flag I can use latter on in set analys or as a selection field.

Original:

Load Date1, Value, Date2

from DataSource;

Fact:

Load Date1 as Date,

'1' as FactType,

Value

Resident Original;

Concatenate(Fact)

Load Date2 as Date,

'2' as FactType,

Value

Resident Original;

drop table Original;

Hope this helps,

Erich

topic Script problem in QlikView

Script problem

Script problem