How to have development and production for SQL to QVW ?

[paulyeo11]

‌Hi All

in the past I have development file which read text file to decode the data by add syntax to make data able for Qlik View create chart and table.

Now I am no more read data using txt file . Instead I use QV directly read SAP SQL table .

So I need to have 2 development QVW file :-

1. one QVW just to read the SQL table and save as file1.QVW

2. Another QVW file to read file1.QVW and decide by add syntax and save as file2.QVW

3. Now I need another production file

[paulyeo11]

‌Hi All

Slorry I post too early .

step 3 The production QVW is to just for create all table and chart. There is min syntax in load script.

My Question is , how to reduce the above 3 step into 2 ?

HHope some one can advise me.

[vishsaggi]

Just move your charts and tables in your step 2, i.,e in your file2.qvw and run this file2.qvw on PROD.

[paulyeo11]

Hi Vish

Thank you very much for your sharing.

If I do that , how to handle the part that connect to SAP server to access the server SQL table ? As I can not do it off line programming.

Unlike if I load from TXT file. I can program off line.

Hope you can share with me.

Paul Yeo

Director

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[paulyeo11]

‌Hi Vish

i mean for file 1 QVW , May I know if I am at home I unable to reload script.

HOw to make it I am able to reload with out any error as my Note book does not link to SAP server.

[vishsaggi]

‌why don’t you save the data to a qvd. Like

yyour load script ....;

store yourtablename into c:\foldername\yourtablename.qvd(qvd);

then hen you can load data from qvd in the other file where you don’t need to connect to SAP.

HOpe this helps.

[paulyeo11]

‌Hi Vish

THank you very much for your sharing.

Paul

[vishsaggi]

‌No problem let me know how it goes.