Discussion board where members can get started with QlikView.
I would like to speed up calculations in application by putting it on script level.
I need to create another column with a calculation so it will speed up my application.
So here is the data:
Table 1 - Cars
Table 2 - Maintenance
I would like to sum "Delivery" with "Timeframe" and name it as "date of maintenance" and put in Table 3.
Here is my desired Table:
I will appreciate If someone can help me! Just though of creating another table because it will simplify the view, but if you have an easier way it would be great!
thanks in advance.
(html, codepage is 1252, embedded labels, table is @1);
[Type of maintenance],
(html, codepage is 1252, embedded labels, table is @2);
Date(Delivery + [Timeframe (Days)]) as [Date of Maintenance]
DROP Table Table;
View solution in original post
Thank you very much!
it helped a lot.
I am glad it did help. Would you mind closing this thread by marking the correct answer.