Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Vlookup in Qlikview

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

3 Replies
Not applicable

Vlookup in Qlikview

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

Not applicable

Vlookup in Qlikview

try with applymap()

ngulliver
Valued Contributor III

Vlookup in Qlikview

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

Community Browser