Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Error

HI ALl,

I have writtena Apply Map in the script .

and after reloading it gives me the error .

please find the screenshot of the error and the script

Tahnks in Advance

1 Solution

Accepted Solutions
Colin-Albert

The ApplyMap function is used to translate a field from one value to another. The field you are translating must exist in the data.

The source data for test2 MUST contain RSeverity  then applymap function will translate the value and return the second value from the mapping table. If the data does not contain RSeverity, then you get the error you are seeing.


Look at this post to see how Applymap works.

Don't join - use Applymap instead

View solution in original post

14 Replies
Chanty4u
MVP
MVP

try below

applymap('test',Rseviarity,null()) as new

prma7799
Master III
Master III

Try this

applymap('Testfor_D',RSeviarity,null()) as Sev



ApplyMap ‒ QlikView

https://community.qlik.com/thread/98764

prieper
Master II
Master II

Rseviartiy is not a field in the database, where the APPLYMAP-command stands

dinuwanbr
Creator III
Creator III

Hi  Roy,

What is the error you are getting?

Here I hope that error is nothing but there may be no records to be mapped or there may be more than one value to be mapped (hence showing the very first value)

Before you do apply map please check whether

there are one [Ready for Release] for each RSeverity in Test_for_D.

It has to be a one value only. If not you can't do an apply map.

Rgds,

Tharindu

Anil_Babu_Samineni

Expression should return. Can you create inline atleast 5 records and check

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
smilingjohn
Creator III
Creator III
Author

Hi Anil ,

There too much of data no need to create records using inline table .

But still this is giving the same error.

I changed the fields and added ApplyMap

but still dosnot work ...

It gives the same error , like field not found

I am doing anything wrong ?

jonathandienst
Partner
Partner

Please stop trying to fix the ApplyMap statement - there is nothing wrong there.

As Peter R has already said, the field RSeviarity is not a field in the table where you are using the ApplyMap...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
effinty2112
Master
Master

Hi John,

You've commented out the RSeverity field that your ApplyMap statement is looking for. QV is giving you a good clue -

Field not found - <RSeverity>

cheers

Andrew

Anil_Babu_Samineni

May be field consider in mapping table as space after word. Try to use the simple ApplyMap or with out that load only first QVD

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)