QV to QS Migration - script issue

Hannah_M — Tue, 05 Jul 2022 20:08:54 GMT

Hi,

I am migrating an app from QV to QS and this section of script works fine in QV but I am getting script errors in QS. Can someone please tell me what needs to change? Thanks!

Re: QV to QS Migration - script issue

Lisa_P — Tue, 05 Jul 2022 23:39:51 GMT

If your Path and QVD variables are valid within Qlik Sense syntax, the next thing is what is it testing using this if condition ? If QvdCreateTime of that QVD is what

Re: QV to QS Migration - script issue

Hannah_M — Wed, 06 Jul 2022 13:08:44 GMT

Hi Lisa,

Thanks for your response. The path variable is correct. That is my question as well. I did not create this script and the person who did no longer works here. But what I do not understand, is I can run the app in QV, and it runs without any errors.

Here is the full script, if that helps.

Sub UpdateQVD(xFile)
//*****************************************
//Based on file name, determine file type and define variables for incremental loading

//Assign File Type a Number for Switch Statement
Let xFileName = Subfield(SubField('$(xFile)','\',-1),'.',1);
Let xFileType = Match(Left('$(xFileName)',3),'CUW','Foc','Hit');
Let xPeriod = Right('$(xFileName)',6);
//Assign QVD name, Excel Document Prefix, Excel Sheet Name, and Period Suffix to file based on Type
Switch xFileType

Case 1 //Exceptions Summary

Set xQVD = 'ExceptionsSummary.qvd';
Set xExcel = '$(vExceptions)';
Set xSheet = '$(vExceptionsSheet)';

Case 2 //Policy Summary

Set xQVD = 'PolicySummary.qvd';
Set xExcel = '$(vPolicy)';
Set xSheet = '$(vPolicySheet)';

Case 3 //Hit Rate

Set xQVD = 'HitRate.qvd';
Set xExcel = '$(vHitRate)';
Set xSheet = '$(vHitRateSheet)';

EndSwitch

//*****************************************
//Incremental Load
If QvdCreateTime('$(vQVDPath)/$(xQVD)')
//OldData
Data:
Load * From "$(vQVDPath)/$(xQVD)" (qvd) WHERE Period <> '$(xPeriod)';
ENDIF

//NewData
Data:
Load '$(xPeriod)' as Period, *
FROM
"$(vFilePath)/$(xExcel)$(xPeriod).xlsx"
(ooxml, embedded labels, table is [$(xSheet)]);

//Store Data and Drop Table
Store * from Data into "$(vQVDPath)/$(xQVD)";

Drop Table Data;

ENDSUB

Re: QV to QS Migration - script issue

marcus_sommer — Fri, 08 Jul 2022 10:05:26 GMT

Sense requires within the standard-mode specified connections to the sources which are then called with lib - I assume that's not done yet. Alternatively you may enable the legacy-mode which accept the previous QlikView syntax.

- Marcus

topic Re: QV to QS Migration - script issue in App Development

QV to QS Migration - script issue

Re: QV to QS Migration - script issue

Re: QV to QS Migration - script issue

Re: QV to QS Migration - script issue