topic Re: set analysis in loading script in QlikView

set analysis in loading script

souadouert — Thu, 13 Sep 2018 11:25:52 GMT

Hello,

i neeed to know if i can uses set expression in load statement for example Have _exp Variable

SALES :

load

PRODUCT,SALES from SALE;

product:

PRODUCT, name ,from products

let _exp ='sum({< PRODUCT={'P1'}>}1)';

let _name='EXP1'

LOAD

* ,

'$(_exp )' as $(_name)

RESIDENT product

Or — Thu, 13 Sep 2018 11:32:06 GMT

There is no set analysis in script. You'll have to use good, old-fashioned conditional statements like if().

YoussefBelloum — Thu, 13 Sep 2018 12:28:25 GMT

Hi,

no set expressions on script, but for the _exp variable ='sum({< PRODUCT={'P1'}>}1)'; you can try this:

table:

load

if(PRODUCT='P1', 1) as SUM

group by

all fields except SUM