Data Manipulation in Qlikview

[Anonymous]

Hi,

I am developing in Qlikview and want to optimize calculations and reduce time by making it in load script. 

So I made it using three tables as shown below:

Table 1: (Columns)

Model - Timeframe - Maintenance Type - US$

Table 2: (Columns)

Model - Timeframe

Table 3: (Columns)

Model - Maintenance_Start - Serial Number

What I did and want to know if it is right. Mapped table's 2 Timeframe inside Table 3 (using Model as key) and calculate date of maintenance by Maintenance_Start*Timeframe (table 2) as Maintenance_Date. Having it, can I see in a chart all the Maintenance Type and US$ (Table 1) respectively by Maintenance_Date? Is that possible or do I need to exclude table 2 and have the calculations on the chart?

Thank you in advance.

[Anonymous · Accepted solution]

How to create another Column in script

here's is the correct step.