topic Re: How to set network path in QLIKSENSE in App Development

How to set network path in QLIKSENSE

gauravkhare — Fri, 02 Sep 2016 16:13:57 GMT

Hello community,

I' am stuck with this issue where i m not able to store qvd onto a network location.

This is how I' am doing

Declared path

vQvdPathExtract= 'LIB//GAKA/GA_QVD/Extract'

then i m fetching data from sql server. Now when i try to create qvd, it throws error

store tablename into "LIB://vQvdPathExtract/tablename.qvd";

kindly help me out

Thanks

Re: How to set network path in QLIKSENSE

Fri, 02 Sep 2016 16:38:04 GMT

this is the format try this

Table name :

LOAD *;

SQL SELECT

FROM "table name in SQL "(exactly the same);

store Table name into [QVD NAME.qvd ](qvd);

drop table TABLE NAME ;

just replace your table name here and make sure you have connection to odbc .

save you qvd near your qlik view or qlik sense document

when you write the script in qlik view or qlik sense

table name :

column 1,

column 2,

From

[QVD NAME .qvd ](qvd);

I even suggest you, create all your documents in qlik view and just create a binary link in qlik sense , which is easy.

Re: How to set network path in QLIKSENSE

Fri, 02 Sep 2016 17:02:45 GMT

Hi Vasu, thanks bt your solution won't work in QlikSense

Re: How to set network path in QLIKSENSE

Fri, 02 Sep 2016 17:53:36 GMT

can u see at the bottom i mentioned some thing ..

First of all create the doc in qlik view and do a binary load which is simple

Script for Binary load

Binary [lib://Name of the connection /NAME of the document];

Name of the connection :

It should be a folder < go to data load editor< create new connections<Folders < Folder path(path of qvw) eg :H/documets/qvw<at the bottom of connection name it(use this one in binary name of connection)<click create<name of the qvw< add all the additional files and supporting documents in the next sections < Load data

this will work

Re: How to set network path in QLIKSENSE

Thu, 29 Sep 2016 15:31:05 GMT

did it work ?

Re: How to set network path in QLIKSENSE

Fri, 30 Sep 2016 06:29:20 GMT

Hello Vasu,

Yeah things are working for me now. Actually it was mistake from my end.. Thanks Vasu

Re: How to set network path in QLIKSENSE

Fri, 30 Sep 2016 15:21:17 GMT

Can u mark it as answered . thanks