Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to load a qlikview document, in the script I have commands like the following:-
if([PD PH Status] = '10','Released to Warehouse',
if([PD PH Status] >= '20' and [PD PH Status] <= '40', 'In Picking/Packing',
if([PD PH Status] = '70','Loaded on Trailer'))) as [PD Status];
I have attached the script as in many places I need to quicken the load but I'm not sure how to.
Would be grateful for the help.
Refresh time depend on the lot of factor. You can try with mapping load or interval match. Test the reload time for 3 cases and you can use which method take less time.
You can look into a MAPPING approach, like you already did in other places of your script.
How can I use mapping when there are <= and >= parameters?
If status is an integer, you can create a mapping table like
MAP:
MAPPING
LOAD Min+iterno()-1 as F1, Map
while Min+iterno()-1 <= Max;
LOAD Min, Max, Map INLINE [
Min,Max, Map
10,10,Released to Warehouse
20,40,In Picking/Packing
70,70,Loaded on Trailer
];
LOAD
Status,
ApplyMap('MAP', Status,'No StatusText mapped') as StatusText,
...