How to set network path in QLIKSENSE

[gauravkhare]

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

[#2]

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.

[#3]

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

[#4]

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

[#5]

did it work ?

[#6]

Hello Vasu,

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

[#7]

Can u mark it as answered . thanks