I am not sure what defines a valid expression for variables in the data load editor:

For example: 

INCORRECT:  Let vLastExecDate = max(date);

CORRECT: Let vLastExecDate = peek('date', 0, 'table_name'));

OR

INCORRECT: LET vIsS3TablePresent = NoOfRows('check_s3')>0;

INCORRECT: LET vIsS3TablePresent = if(NoOfRows('check_s3')>0, 1, 0);

What am I missing? This is an issue I face every month and I haven't pinned down what makes an expression valid for LET variable creation method.

Hello, 

I am panicking.

Changed data model and impacting my tables now. Now I have multiple rows of data with the same ProgramName with multiple Events and QlikSense is hiding data in the table. Just Added RecordID

I want to see NA and ProgramName A, Events 1 and 2.
Qliksense is Program A, but the Event Field is blank, but there is data there. 
Assume somehow I have to include Distinct events. Any recommendations?

Currently using:
IF(Region = 'NA' and ProgramName = 'A', [ProgramName],Null())

I am building a table of Objectives and Controls - I have all of the Controls in Qlik but some have missing Objective and Objective Description fields  

I also want to add Objective Number and Control Number which are new fields.

I have created a spreadsheet, to upload the missing data and the new fileds.

I am attempting LEFT JOIN in the load script, but none of the data is loading and I have no errors.

Thanks

Hi, we would like to have our Qlik Sense Mobile in Microsoft Intune for devices under iOS platform but have an issue with understanding the app xml configuration. Unfortunately, I only found a json configuration template in Qlik forum. The following is the configuration template that Microsoft provides for us: 

<dict>
<key>userprincipalname</key>
<string>{{userprincipalname}}</string>
<key>mail</key>
<string>{{mail}}</string>
<key>partialupn</key>
<string>{{partialupn}}</string>
<key>accountid</key>
<string>{{accountid}}</string>
<key>deviceid</key>
<string>{{deviceid}}</string>
<key>userid</key>
<string>{{userid}}</string>
<key>username</key>
<string>{{username}}</string>
<key>serialnumber</key>
<string>{{serialnumber}}</string>
<key>serialnumberlast4digits</key>
<string>{{serialnumberlast4digits}}</string>
<key>udidlast4digits</key>
<string>{{udidlast4digits}}</string>
<key>aaddeviceid</key>
<string>{{aaddeviceid}}</string>
<key>IsSupervised</key>
<string>{{IsSupervised}}</string>
</dict>

I just wonder whether anyone has had any experiences with xml app configuration in Intune for iOS devices. I am looking for the description for each string I need to fill in and whether I have to follow this template and complete all those keys to enable the configuration. Thank you.