quickest load method

[qlikmpate0]

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.

[#2]

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.

[swuehl]

You can look into a MAPPING approach, like you already did in other places of your script.

[qlikmpate0]

How can I use mapping when there are <= and >= parameters?

[swuehl]

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,

     ...