Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The message you are trying to access is permanently deleted.
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...