topic How to assign a SQL-Query-result to a variable? in QlikView

How to assign a SQL-Query-result to a variable?

Thu, 21 Nov 2013 13:01:03 GMT

Hello,

following Question:

I got a SQL-statement which provides the maximum of a database field.

For example: select max(field1) as result from table1

How can I assign this sql-result-value to a qlikview-variable?

let @vMAXIMUM = ?

Thanks for your help!

Daniel

Thu, 21 Nov 2013 13:02:51 GMT

Hi,

LOAD the sql into a table

use the peek() function to populate your variable

drop the table

Fabrice

CELAMBARASAN — Thu, 21 Nov 2013 13:04:16 GMT

It cannot be assigned directly

try like this

Table1:

SQL SELECT Max(field1) as Result FROM table1;

LET vMAXIMUM = Peek('Result', 'Table1');

DROP Table Table1;

tresB — Thu, 21 Nov 2013 13:04:26 GMT

Try like:

Load Max(field1) as MaxValue;

SQL Select field1 From <data source>;

Let vMax=Peek('MaxValue');

Thu, 21 Nov 2013 13:06:58 GMT

Thanks for your incredible fast help!

rvsaraswat — Mon, 09 Nov 2020 10:48:58 GMT

Hi, I am doing the same but getting a null value in the variable.

A:
SQL
select trunc(max(Event_Date)) as Result from Event;

LET vMaxDate = peek('Result','A');

Please help