Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data Manipulation in Qlikview

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

1 Reply
Anonymous
Not applicable
Author

How to create another Column in script

here's is the correct step.