topic Re: How to have development and production for SQL to QVW ? in QlikView

How to have development and production for SQL to QVW ?

paulyeo11 — Sat, 16 Jun 2018 12:57:28 GMT

‌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

Re: How to have development and production for SQL to QVW ?

paulyeo11 — Sat, 16 Jun 2018 13:01:36 GMT

‌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.

Re: How to have development and production for SQL to QVW ?

vishsaggi — Sat, 16 Jun 2018 16:02:21 GMT

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

Re: How to have development and production for SQL to QVW ?

paulyeo11 — Sat, 16 Jun 2018 23:50:38 GMT

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>

Re: How to have development and production for SQL to QVW ?

paulyeo11 — Sun, 17 Jun 2018 02:48:12 GMT

‌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.

Re: How to have development and production for SQL to QVW ?

vishsaggi — Sun, 17 Jun 2018 03:05:27 GMT

‌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.

Re: How to have development and production for SQL to QVW ?

paulyeo11 — Sun, 17 Jun 2018 03:08:45 GMT

‌Hi Vish

THank you very much for your sharing.

Paul

Re: How to have development and production for SQL to QVW ?

vishsaggi — Sun, 17 Jun 2018 03:25:32 GMT

‌No problem let me know how it goes.