topic how to use external files into dasboads in QlikView

how to use external files into dasboads

krishna789 — Wed, 25 Nov 2020 16:16:04 GMT

how use external files into dasboards ( connection string, usernmae and password etc )

Re: how to use external files into dasboads

Anil_Babu_Samineni — Mon, 20 Mar 2017 10:01:34 GMT

May be Binary Load / You could create one txt file for String and remaining. Then call txt file by help of Must_Include(Path/Filename.txt)

Re: how to use external files into dasboads

Anonymous — Mon, 20 Mar 2017 10:03:23 GMT

What type of external files are you having issues loading?

Re: how to use external files into dasboads

vijetas42 — Mon, 20 Mar 2017 11:04:09 GMT

you can use include command like, $(include=\\path of the folder\file_name.extension)

Re: how to use external files into dasboads

avinashelite — Mon, 20 Mar 2017 11:19:42 GMT

Your trying load the data from QVS ? or txt

check this

Importing text files containing scripts?

Re: how to use external files into dasboads

krishna789 — Mon, 20 Mar 2017 12:12:02 GMT

hello ,avinash i am loading data through from sql and i want to hide path so, i am saving path in qvs . while accessing qvs files again path is showing can i hide the path.

Re: how to use external files into dasboads

avinashelite — Mon, 20 Mar 2017 12:36:12 GMT

In the load script its showing up ? Yes it will including the path in QVS won't hide path from logs or load script

only option for this is to use the hidden script option

Go to Edit Script> File > Create Hidden script >

add the SQL connection part which you don't want to show

NOTE: If you forget the Hidden script password then you cannot be recover . So make a note of the password

Hope this helps you

Re: how to use external files into dasboads

krishna789 — Tue, 21 Mar 2017 06:28:56 GMT

hi thanks i got it ..

Re: how to use external files into dasboads

krishna789 — Tue, 21 Mar 2017 06:41:45 GMT

actually my doubt is while connecting to my sql i will get

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=krg;Initial Catalog=Pro;Data Source=SAT;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SATI;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is BHCOeZFOMbD); here we can see user id,which system it belong to everthing we can see..so want to load data but it shoukld hide...so before that save your 'OLEDB in notpad and through qlikview by <insert>include statement>browser will select the text file then you can see that OLEDB FILES IN NOTEPAD is load in this formate ' $(Include=kri.txt);' here we can see no details of server ,we can access this file.

but thanks for your try...

Re: how to use external files into dasboads

avinashelite — Tue, 21 Mar 2017 08:01:02 GMT

Got your question ..I think once your connected to that source ...you could remove the RIGHT hand side info I guess

just keep

OLEDB CONNECT32 TO connection_name

this will work