topic Re: Excel Conversion QlikView in QlikView

Excel Conversion QlikView

pgalvezt — Tue, 24 May 2016 14:07:16 GMT

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

Re: Excel Conversion QlikView

sunny_talwar — Tue, 24 May 2016 14:08:53 GMT

Can you share the QlikView and the Excel document?

Re: Excel Conversion QlikView

pgalvezt — Tue, 24 May 2016 14:13:06 GMT

Hi Sunny,

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

Re: Excel Conversion QlikView

sunny_talwar — Tue, 24 May 2016 14:22:30 GMT

It seems to be working, what is the issue?

Re: Excel Conversion QlikView

pgalvezt — Tue, 24 May 2016 14:31:27 GMT

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.

Re: Excel Conversion QlikView

pgalvezt — Tue, 24 May 2016 17:10:21 GMT

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