topic Load Basic in App Development

Load Basic

Mahamed_Qlik — Sun, 27 Aug 2023 08:15:07 GMT

I have field as below :

A1
A2
A3
A5 ......till A2000

I want to apply filter to load only less than A150.

rubenmarin — Sun, 27 Aug 2023 09:26:44 GMT

Hi, if all the values has a letter and a number you can use something like:

LOAD * from/resident... Where Mid(FieldName,2)<150;

anat — Sun, 27 Aug 2023 13:46:05 GMT

if you have other letters then go with purgechar like below:

LOAD * Where PurgeChar(ID,'ABCDEFGHIJKLMNOPQRSTUVWXYZ')>5;
LOAD * Inline [
ID
A1
A2
A3
A4
A10
A11
A12

];