Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

I have issue with ['lib://vFOLDER\JEREMY\Sales_Order.csv']

Hi All

I have below script from QVW file working fine  :-

LOAD

Subject,

     [Opportunity Name],

     [Customer No],

     Date(Date#([Due Date],'DD-MM-YYYY'),'YYYY-MM-DD') as DATE,

     Date(Date#([Due Date],'DD-MM-YYYY'),'YYYY-MMM') as YEARMONTH,

     Date(Date#([Due Date],'DD-MM-YYYY'),'YYYY') as YEAR,

     Date(Date#([Due Date],'DD-MM-YYYY'),'MMM') as MONTH,

     Carrier,

     Pending,

     Status,

     Description

FROM

(txt, utf8, embedded labels, delimiter is ',', msq);

My question is how can i convert this file to QVF.

I have try to copy and paste the above script to Qlik Sense. I get the below error :-

The following error occurred:

This statement only works with lib:// paths in this script mode

So i have create a Lib folder name = vFOLDER for below directory :-

C:\Users\Paul Yeo\Dropbox\Jeremy

Now my question is how should i modify the below script :-

I have try :-

['lib://vFOLDER\JEREMY\Sales_Order.csv']

I still get error.

May i know where i go wrong ?

Paul Yeo

1 Solution

Accepted Solutions
mattquinnterex
Contributor II

Re: I have issue with ['lib://vFOLDER\JEREMY\Sales_Order.csv']

Hi Paul, it is most likely because you have not set up a connection within Qlik Sense, so the application does not know what file location you are talking about.

While in the data load editor you will have to create a new connection to the specific folder and then load it in from there.

Also an Easier way to show the YEAR from a date is to use the Year() function

     i.e. Year([Due Date]) as YEAR

Hope this helps, let me know how you get on.

1 Reply
mattquinnterex
Contributor II

Re: I have issue with ['lib://vFOLDER\JEREMY\Sales_Order.csv']

Hi Paul, it is most likely because you have not set up a connection within Qlik Sense, so the application does not know what file location you are talking about.

While in the data load editor you will have to create a new connection to the specific folder and then load it in from there.

Also an Easier way to show the YEAR from a date is to use the Year() function

     i.e. Year([Due Date]) as YEAR

Hope this helps, let me know how you get on.

Community Browser