error in edit script

[#1]

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!

[danansell42 · Accepted solution]

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

[bertinabel]

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.

[vishsaggi]

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 ......

[#5]

great, it worked!! thanks a ton!!

[#6]

thanks for your reply, this method worked as well

[#7]

thanks a ton..much appreciated

[Anonymous]

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