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.
