Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Can you share the QlikView and the Excel document?
Hi Sunny,
I prepared a ex that What I want to do in QlikView.
It seems to be working, what is the issue?
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.
Found The Issue... I change the database now works fine...