Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Script problem

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???????

1 Reply
erich_shiino
Honored Contributor

Script problem

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

Community Browser