assign database value to variable in script

[#1]

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.

[CELAMBARASAN · Accepted solution]

Hi,

     Temp:

     Load Max(ColumnName) as MaxValue Resident TableName;

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

     Drop Table Temp;

Hope it helps

Celambarasan

[jagan]

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.

[perumal_41]

Hi

Use This Script

TempMax:

Select

     Max(Sales) AS Sales

FROM Sales;

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

  Drop Table TempMax;

Regards

Perumal A