Data Manipulation in Qlikview

Anonymous — Sun, 25 Oct 2015 13:59:56 GMT

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.

Re: Data Manipulation in Qlikview

Anonymous — Mon, 16 Nov 2015 13:42:08 GMT

How to create another Column in script

here's is the correct step.

topic Re: Data Manipulation in Qlikview in QlikView

Data Manipulation in Qlikview

Re: Data Manipulation in Qlikview