Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

variable in script

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

1 Solution

Accepted Solutions
Chanty4u
Champion III
Champion III

small change for abve

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

View solution in original post

17 Replies
Chanty4u
Champion III
Champion III

chk dis

Let Statement

Not applicable

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

Chanty4u
Champion III
Champion III

what ur exctly tryng to do?

Not applicable

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

Chanty4u
Champion III
Champion III

is this?

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

t_chetirbok
Specialist
Specialist

hello!

try this

LET varCons = ApplyMap('map_coda_number_codes',1490)

tamilarasu

Hi,


Simply try,


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

Chanty4u
Champion III
Champion III

small change for abve

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

View solution in original post

t_chetirbok
Specialist
Specialist

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