Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have an issue with a data load script in Qlik Sense 1.1, when I inserted a variable into FROM clause.
Works well in normal:
(ooxml, embedded labels, table is Sheet1);
Works well with path variable:
LET vExamplePath = 'lib://example\';
But does not work with fullpath variable:
LET vExamplePath = 'lib://example\example.xlsx';
Go to Solution.
Try this: - surround in [ ] as in:
Set vPth = 'lib://data/Excel_Report_1.xlsx';
'North America' as Continent,
'United Sates' as Country,
'Southern' as Region,
Year(OrderDate) as Year,
Month(OrderDate) as Month,
(ooxml, embedded labels, header is 4 lines, table is Southern)
Where State <> 'Total';
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Thank you Michael!
It was the right solution.