topic quickest load method in QlikView

quickest load method

qlikmpate0 — Fri, 22 Jan 2016 15:52:57 GMT

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.

Re: quickest load method

Fri, 22 Jan 2016 16:00:12 GMT

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.

Re: quickest load method

swuehl — Fri, 22 Jan 2016 16:01:32 GMT

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

Re: quickest load method

qlikmpate0 — Fri, 22 Jan 2016 16:05:23 GMT

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

Re: quickest load method

swuehl — Fri, 22 Jan 2016 16:13:03 GMT

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,

...