lookup does not work correctly

thuesmann — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have a SourceData table with a calculated field VNabenhoehe_WKA01_110 that contains calculated decimal numbers rounded to one decimal place.

the formula looks as follows:

round(met_WindSpeedRot_mean * pow((110/77.5),0.15), 0.1) as VNabenhoehe_WKA01_110

SourceData table:

TimeStamp	StationId	met_WindSpeedRot_mean	VNabenhoehe_WKA01_110
01.01.2022 01:10	38	6,578205109	6,6
01.01.2022 01:20	38	6,533299923	6,5
01.01.2022 01:30	38	6,63405323	6,6
01.01.2022 01:40	38	6,766101837	6,8
01.01.2022 01:50	38	7,357340813	7,4
01.01.2022 02:00	38	7,764773846	7,8

Now I have another table also with the field VNabenhoehe_WKA01_110 and and a second value MatchPower that I would like to integrate into the SourceData table. Like you would do with a simple lookup funktion in excel

VNabenhoehe_WKA01_110	MatchPower
0,0	100
0,1	200
0,2	300
0,3	400
0,4	500
0,5	600
0,6	700
0,7	800
0,8	900
0,9	1000
1,0	1100

I tried to do this via the lookup function in qlikview and it worked out quite well to a large extent. However, there are several values in the SourceData table that didn't end up with a matching MatchPower value.

Is there a problem in doing a lookup based on decimal numbers?

Do I have to use a join?

Any other suggestions?

Glad to get some help 😉

Re: lookup does not work correctly

marcus_sommer — Fri, 05 Jan 2024 09:38:43 GMT

Qlik is using a binary number-system which couldn't always provide exact frac-parts. Workarounds for such challenges may be to apply the same kind of rounding to each relevant field or just multiplying the values (10 in your case) to apply the matching against integers.

More background is here: Rounding Errors - Qlik Community - 1468808.

topic lookup does not work correctly in QlikView

lookup does not work correctly

Re: lookup does not work correctly