topic Help with Load Script in QlikView

Help with Load Script

jagjivvt — Tue, 23 Feb 2010 16:54:09 GMT

i am applying the script below but it does not work, please provide me with a solution as it works perfect in excel as shown below.

'=IF(O2<0,"Expenses",IF(AND(L2="BGC",RIGHT(G2,6)<>"602210"),"Cheques other",IF(AND(G2="MANPOWER UK LTD",LEN(H2)=3),"Cashbook",IF(AND(L2="IBP",I2="Manpower UK LTD"),"Cashbook",IF(AND(OR(L2="CHP",L2="IBP"),LEN(I2)=0),G2,IF(OR(L2="CHP",L2="IBP"),I2,G2))))))

if(Amount <= '0', 'Expenses', if (Type = 'BGC' + right([Narrative #1], 6)<> '602210'

'Cheques Other'

, if ([Narrative #1] = 'MANPOWER UK LTD' + LEN([Narrative #3]) = '3', 'Cashbook'

(Type = 'IBP' + [Narrative #3] = 'MANPOWER UK LTD'), 'Cashbook', if(or(Type = 'CHP', Type = 'IBP'

len

([Narrative #3] = '0', [Narrative #1], if(or(Type = 'CHP', Type = 'IBP'), [Narrative #3], [Narrative #1]))))) as [New Narrative]

thanks

vijay

Help with Load Script

Tue, 23 Feb 2010 17:17:25 GMT

The first is Excel and the second is using the same logic in your Load Script?

First, you use and inside if statements.

if (Type = 'BGC' and right([Narrative #1], 6)<> '602210'

I also don't think there is an or() function, use:

if(Type = 'CHP' or Type = 'IBP'

It would also be a lot easier to read the expression if you pasted it as plain text inside [ code] [ /code] tags (without the spaces).

Help with Load Script

tseebach — Tue, 23 Feb 2010 17:51:02 GMT

Instead of the OR() function you can use Match('Field',value1,value2,etc) If any value is found it will return true.

I would suggest that you cut down the formula into smaller parts. A bit like setting some flags. And then have them all put together in the expression dialog for your charts. It make you code cleaner and more flexible.

Although precalculations is always nice 😉