Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to get the MS Excel Vlookup function into Qlikview.
I have two tables: "Uurtarieven" and "Urenterugmelding".
Uurtarieven: two column: "Vakgroep" and "Tarief"
Vakgroep ; Tarief
ET ; Euro 25,--
WT ; Euro 20,--
Urenterugmelding two column: "Werkplek" and "Werkelijke_uren"
ET ; 2
WT ; 3
ET ; 1
ET ; 4
etc.
Qlikview has to make a new column in the table "Urenterugmeldng" named: "Werkelijke_kosten_uren"
In this new column the calculation: Tarief x werkelijke_uren
Excel Formule: Werkelijke_kosten_uren = (Werkelijke_uren x Vlookup(werkplek; uurtarieven, tarief; 2))
Can someone help me with a script.
Thanks,
Ralph
Hi,
I think this will help you.
Initial_tables:
load
Vakgroep,
Tarief
from Uurtarieven;
join
load
Werkplek as Vakgroep,
Werkelijke_uren
from Urenterugmelding ;
End_table:
noconcatenate load
Vakgroep,
Tarief,
Werkelijke_uren,
Tarief*Werkelijke_uren as Werkelijke_kosten_uren
resident initial_tables;
drop table initial_tables;
BR
Alex
try with applymap()
Hi,
If you want to have a look at how to use applymaps, have a look at Steve Dark's blog:
http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Very useful.
Regards,
Neil