topic Issue in assigning values to variables in QlikView

Issue in assigning values to variables

Mon, 30 May 2011 11:46:12 GMT

Good Evening,

I have a stragne issue, in the below I am Loading the maximum value of Euro and storing in Lmax variable and I can see the value in using text object.

But when I assign the Lmax to MEuro it shows the null value.

What is the issue in it.

Leasd:
Load Max(Euro) as Lmax
FROM c:\test\QVFW.QVD (qvd) ;

Let MEuro=Lmax

map1

mapping load
[Euro],[Invoice Number]
FROM c:\test\QVFW.QVD (qvd) ;

let MaxInv=ApplyMap ( 'map1', Lmax )

Regards

Joe

Issue in assigning values to variables

Mon, 30 May 2011 11:56:14 GMT

Test to do it in a couple of steps - load everything you need from .qvd beforehand without any transformation and then use e.g. Max and Mapping Load resident...

/@Ungvall

Issue in assigning values to variables

pat_agen — Mon, 30 May 2011 13:24:09 GMT

Hi,

Lmax is a field in the table Leasd. Try this to give the value to Meuro:

LET MEuro=peek('Lmax',-1,Leasd);

if LET doesn't work try SET!