How to convert excel formula in to qlikview

[#1]

Hi i have excel formula

=IFERROR(VLOOKUP($A10,'Base Data'!$A:$O,2,0),0)

how to use this formula in qlikview pivot table expression

[Gysbert_Wassenaar]

Not. Qlikview is not a spreadsheet application. This kind of formula cannot be converted to a Qlikview chart expression..

[jagan]

Hi,

As Gysbert said Qlikview is not a Spreadsheet app.  May be this can be done using some workaround in script/expression if possible.  But with the formula alone it is not possible to give answer.  If you are creating a discussion, first prepare some sample data and attach data/file and your expected output, so that it would be easier to give solution. 

Regards,

Jagan.

[DavidFoster1]

In the front-end that is not possible in QlikView, but in the script your excel formula is a good match for APPLYMAP with a default value.

APPLYMAP('Base_Data',[Key],0) as [Field Name]