topic assign database value to variable in script in QlikView

assign database value to variable in script

Wed, 14 Mar 2012 05:34:01 GMT

Hi,

I want to fetch maximum value from the column and assign it to a variable in qlikview while scripting. Can anybody tell me how is it possible?

Thanks in advance.

assign database value to variable in script

CELAMBARASAN — Wed, 14 Mar 2012 05:47:22 GMT

Hi,

Temp:

Load Max(ColumnName) as MaxValue Resident TableName;

Let vVariable=FieldValue('MaxValue',1);

Drop Table Temp;

Hope it helps

Celambarasan

assign database value to variable in script

jagan — Wed, 14 Mar 2012 05:55:00 GMT

Hi,

Check the script below

TempMax:

Select

Max(Sales) AS Sales

FROM Sales;

Let vMaxValue = FieldValue('Sales',1);

Drop Table TempMax;

Hope it helps you.

Regards,

Jagan.

assign database value to variable in script

perumal_41 — Wed, 14 Mar 2012 06:33:39 GMT

Hi

Use This Script

TempMax:

Select

Max(Sales) AS Sales

FROM Sales;

Let vMaxValue = Peek('Sales',1,TempMax);

Drop Table TempMax;

Regards

Perumal A