topic Re: How to write an expression with applymap in QlikView

How to write an expression with applymap

Mattia — Sat, 16 Nov 2024 02:07:19 GMT

Hi Guys,

i need to write an expression in the script with the following output: when the field [@29:33] =35, the new field TIPO must show "ODONTO". The field [@29:33] is in table "D" while the field [@10:17] is the key between table "T" and "D".

I've tried with:

KEY_TO_UO_RIFERIMENTO:
Mapping LOAD
[@10:17] as CONTATORE_PRESCRIZIONE,
[@29:33] as UO_RIFERIMENTO

If(ApplyMap('KEY_TO_UO_RIFERIMENTO',[@10:17],'n/a')=35,'ODONTO') as TIPO

but don't work.

Can anyone help me?

Thanks,

Mattia

Re: How to write an expression with applymap

sunny_talwar — Thu, 24 Oct 2019 14:33:05 GMT

Don't see any issues... can you mock up the problem in a sample mocked up data for us to see?

Re: How to write an expression with applymap

Mattia — Thu, 24 Oct 2019 14:44:24 GMT

Now it's difficult because i've a lot of data and i can't show them.

The script is the following:

KEY_TO_UO_RIFERIMENTO:
Mapping LOAD
[@10:17] as CONTATORE_PRESCRIZIONE,
[@29:33] as UO_RIFERIMENTO

FROM...

If(ApplyMap('KEY_TO_UO_RIFERIMENTO',[@10:17],'n/a')='35','ODONTO'),
If([@4:9]='001880','DIALISI', If(WildMatch([@10:17],'L*'),'LAB', If(Len(Trim([@10:17]))>0, If([@4:9]='030357','PS_AMB','AMB')))) as TIPO

After the reload, QV show me only "LAB" and "AMB" and i don't know why.

Also, between available fields, i've @10:17...

Re: How to write an expression with applymap

sunny_talwar — Thu, 24 Oct 2019 14:47:34 GMT

All I am asking for is to mock up 5-10 rows of data just like I did here What's wrong in this script? . If you are unable to do this... then I am cannot really spare time each time to create a mock up for you.

Best,
Sunny

P.S. Mock up doesn't need actual data... it can be data which doesn't make sense, but still shows the issue.

Re: How to write an expression with applymap

Mattia — Thu, 24 Oct 2019 15:41:18 GMT

Sorry, Sunny, you're right.

Anyway, you've helped me, because while i'd creating a data sample file, i understand how to solve the problem!

I hope you can help me in the next topics.

Mattia