Excel Conversion QlikView

[pgalvezt]

Hello,

I've trying to do this formula throught mapping / applymap

=VALOR(SI(L2=1;21;CONCATENAR(SI(S2=1;21;SI(S2=2;22;SI(S3=3;24;44)));EXTRAE(BUSCARV(P5;Range;2;FALSO);3;5))))

VALOR(SI(L2=1;21;CONCATENAR(SI(S2=1;21;SI(S2=2;22;SI(S3=3;24;44))) This Value bring me a correct total:

But This Bring me few values EXTRAE(BUSCARV(P5;Range;2;FALSO);3;5))

[sunny_talwar]

Can you share the QlikView and the Excel document?

[pgalvezt]

Hi Sunny,

I prepared a ex that What I want to do in QlikView.

[sunny_talwar]

It seems to be working, what is the issue?

[pgalvezt]

First I need to create Accounts right?

Well, When do clic over VALOR(SI(L2=1;21;CONCATENAR(SI(S2=1;21;SI(S2=2;22;SI(S3=3;24;44)))... QlikView bring me all data for example if  i do clic in 21.... But when do mapping I think qlikview just lookup by Form so QlikView don´t bring me all values. Don´t know why just filter 267 in Form. Because there are more numbers in form that match with the table.

[pgalvezt]

Found The Issue... I change the database now works fine...