topic Re: error in edit script in QlikView

error in edit script

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I am very new to QlikView and have a very silly question.

I have uploaded two tables into QlikView -1. RateTable 2. PolicyData. I wrote an ApplyMap formula to map these tables and extract some information from RateTable into PolicyData table. It is working smoothly. I named this information as a field in the PolicyData as "Rate".

Now, when I want to use this field "Rate" and apply in another formula in Edit Script, it is throwing an error saying "Field "Rate" is not found.

Here is the extract of the code -

......

Plan_option,

Plan_Type,

Key,

Prem_Split,

Age_Gender,

applymap('RateTable',[Age_Gender]) as [Rate],

[Rate]/1000 as [Rate_Mult] {this line is not working}

Can someone please help me. This is kind of urgent.

Cheers!

Re: error in edit script

danansell42 — Thu, 04 Aug 2016 14:12:05 GMT

The field Rate will not be recognized unless it previously existed.

You can fix this in a few ways...

One way would be to add the applymap into the calculated field as follows:

Plan_option,

Plan_Type,

Key,

Prem_Split,

Age_Gender,

applymap('RateTable',[Age_Gender]) as [Rate],

applymap('RateTable',[Age_Gender])/1000 as [Rate_Mult]

Dan

Re: error in edit script

bertinabel — Thu, 04 Aug 2016 14:22:56 GMT

Hi, abhik .

Another solution is to do with a previous load as shown below ;

TableX:

LOAD

[Rate]/1000 as [Rate_Mult];

LOAD

Plan_option,

Plan_Type,

Key,

Prem_Split,

Age_Gender,

applymap('RateTable',[Age_Gender]) as [Rate]

RESIDENT TableY;

Regards.

Re: error in edit script

vishsaggi — Thu, 04 Aug 2016 14:54:02 GMT

Do a preceding load.

Load * ,

[Rate]/1000 as [Rate_Mult] ;

LOAD

Plan_option,

Plan_Type,

Key,

Prem_Split,

Age_Gender,

applymap('RateTable',[Age_Gender]) as [Rate];

FROM ......

Re: error in edit script

Thu, 04 Aug 2016 17:48:54 GMT

great, it worked!! thanks a ton!!

Re: error in edit script

Thu, 04 Aug 2016 17:49:43 GMT

thanks for your reply, this method worked as well

Re: error in edit script

Thu, 04 Aug 2016 17:50:09 GMT

thanks a ton..much appreciated

Re: error in edit script

Anonymous — Thu, 04 Aug 2016 21:36:24 GMT

Hi Abhik,

We're glad to see you were able to solve your issue. Please take a moment to Mark Replies as Correct or Helpful to give points to those who helped and to mark the thread as Answered.

Regards,

Qlik Community Team