Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Just move your charts and tables in your step 2, i.,e in your file2.qvw and run this file2.qvw on PROD.
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>
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.
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.
Hi Vish
THank you very much for your sharing.
Paul
No problem let me know how it goes.