topic Re: variable in script in QlikView

variable in script

Wed, 30 Mar 2016 07:30:12 GMT

Hi,

I have a field in my load script called 'STATUS'. Via applymap I translate this value into an Expression.

Now I want to create in the script a variable, that gives me the translated Expression back.

Currently I have in my script:

LOAD
...

STATUS as asset_statuscode,
ApplyMap('map_coda_number_codes',STATUS) as asset_status,
...

FROM
$(DirDataQVD)efa_asset.qvd
(qvd);

I tried this, but it is not working:

LET varCons = ApplyMap('map_coda_number_codes',STATUS) where STATUS ='1490'

Does someone of you have an idea?

Chris

Re: variable in script

Chanty4u — Wed, 30 Mar 2016 07:36:26 GMT

chk dis

Let Statement

Re: variable in script

Wed, 30 Mar 2016 07:42:03 GMT

Hi chanty,

thanks for your help with the link.

I am not very good at this, so I unfortunately dont understand everything.

Would you please translate this for me for my script.

Thanks

Chris

Re: variable in script

Chanty4u — Wed, 30 Mar 2016 07:47:14 GMT

what ur exctly tryng to do?

Re: variable in script

Wed, 30 Mar 2016 07:50:29 GMT

hi chanty,

the Status 1490 is the code in the Oracle database for under construction.

the applymap is the Translation to get rid of the code and use the Expression.

I want to have a variable with this Expression.

Chris

Re: variable in script

Chanty4u — Wed, 30 Mar 2016 07:52:10 GMT

is this?

LET varCons =' ApplyMap('map_coda_number_codes',STATUS) where STATUS ='1490' ';

Re: variable in script

t_chetirbok — Wed, 30 Mar 2016 07:53:10 GMT

hello!

try this

LET varCons = ApplyMap('map_coda_number_codes',1490)

Re: variable in script

tamilarasu — Wed, 30 Mar 2016 07:54:28 GMT

Hi,

Simply try,

LET varCons = ApplyMap('map_coda_number_codes','1490')

Re: variable in script

Chanty4u — Wed, 30 Mar 2016 07:57:52 GMT

small change for abve

LET varCons = ApplyMap('map_coda_number_codes',1490);

Re: variable in script

t_chetirbok — Wed, 30 Mar 2016 08:01:02 GMT

hm, what is difference between your post and my post? )))

Re: variable in script

Kushal_Chawda — Wed, 30 Mar 2016 08:15:52 GMT

or you can simply filter the Value in Mapping load itself

Re: variable in script

Wed, 30 Mar 2016 08:38:13 GMT

Hi chanty,

thank you it works. But one last question.

I created this variable in a script-qvw (structure file).

My working qvw (it is a layout file) is filled binary with the data from script file.

In this layout file the variable is not there. I think it has something to do with the calcualtion.

Do you know what happens?

Chris

Re: variable in script

Chanty4u — Wed, 30 Mar 2016 08:41:25 GMT

if u do binary load the sheet objects and variables will not come to ur Qvw. only data model will appears.

u can copy objects if u hve same field names in current qvw.

Re: variable in script

Wed, 30 Mar 2016 08:43:47 GMT

thank you very much to all of you.

It works now.

Re: variable in script

tamilarasu — Wed, 30 Mar 2016 08:57:15 GMT

I guess, Suresh was mentioned the semicolon at the end of the statement.

LET varCons = ApplyMap('map_coda_number_codes',1490) ;

Re: variable in script

t_chetirbok — Wed, 30 Mar 2016 08:59:25 GMT

)))) facepalm

Re: variable in script

tamilarasu — Wed, 30 Mar 2016 09:02:55 GMT

Re: variable in script

Anonymous — Thu, 31 Mar 2016 17:17:18 GMT

LET varCons = ApplyMap('map_coda_number_codes',1490) ;