Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.