topic Re: load inline in QlikView

load inline

marcorizzo — Wed, 25 Nov 2020 16:16:04 GMT

I want to create this table but I've got some problem with syntax.

newdimension:

LOAD * INLINE [

newdim,

"if(sum([Importo Effetto]>$(soglia7),'A','')"

];

Any help ?

Many thanks

Marco

Re: load inline

sinanozdemir — Tue, 08 Mar 2016 20:26:59 GMT

Hi,

Just get rid of the extra double quotes and use chr(34):

newdimension:

LOAD * INLINE [

newdim,

chr(34) & if(sum([Importo Effetto]>$(soglia7),'A',' ') & chr(34)

];

Hope this helps.

Re: load inline

rubenmarin — Tue, 08 Mar 2016 22:13:10 GMT

Hi Marco, the brackets of the field name will be interpreted as the en of the Inline table, you can also name the field with double quotes:

LOAD * INLINE [

newdim

if(sum("Importo Effetto">$(soglia7),'A','')

] (delimiter is ';');

If you need both, brackets and double quotes you can also use the ` simbol to enclose the Inline sentence and double-double quotes to force Inline to load the double quotes as part of the string:

LOAD * INLINE `

newdim

""if(sum([Importo Effetto]>$(soglia7),'A','')""

` (delimiter is ';');

Re: load inline

marcorizzo — Wed, 09 Mar 2016 10:09:46 GMT

With your script I've got some error :

This is the result :

any suggestion ?

Thanks

Re: load inline

marcorizzo — Wed, 09 Mar 2016 10:12:01 GMT

Hi. With both script I've got this result

I expected a value as result.

Any suggestion ?

Thanks

Re: load inline

Kushal_Chawda — Wed, 09 Mar 2016 10:18:55 GMT

try this

LOAD * INLINE "

newdim

if(sum([Importo Effetto]>$(soglia7),'A','')

Re: load inline

settu_periasamy — Wed, 09 Mar 2016 10:26:28 GMT

Hi,

May be Like this..

newdimension:
LOAD Replace(Replace(newdim,'|','$'),'^',',') as newdim;
LOAD * INLINE "
newdim,
if(sum([Importo Effetto]>|(soglia7)^'A'^'')
";

Re: load inline

rubenmarin — Wed, 09 Mar 2016 12:00:13 GMT

Hi Marco, to evaluate the expression you can use the $-expansion, please follow the attached example.

BTW, I added a parenthesys to close the Sum()

Re: load inline

marcorizzo — Wed, 09 Mar 2016 12:51:58 GMT

wich example ?

Re: load inline

rubenmarin — Wed, 09 Mar 2016 13:51:08 GMT

The attached qvw:

The first list box has the newdim expression evaluated

Re: load inline

sasiparupudi1 — Wed, 09 Mar 2016 14:23:25 GMT

Please try

chr(34)&'if(sum("Importo Effetto">$'&'(soglia7),'&chr(34)& 'A'&chr(34)&','&chr(34)&chr(34)&')'