topic Re: Input Max value to field in QlikView

Input Max value to field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hey Community

i need that every load some variable will keep the max value of Field1 at the script.

when i use Let Vvalue=Max(Field1) ; from some reason its not working for me any idea ?

Message was edited by: David Benshimol

Re: Input Max value to field

Chanty4u — Mon, 30 May 2016 05:51:36 GMT

did u try wit single quote?

Let Vvalue='Max(Field1)';

Re: Input Max value to field

Anonymous — Mon, 30 May 2016 05:54:05 GMT

But it keep me the string

i need the value

Re: Input Max value to field

tamilarasu — Mon, 30 May 2016 06:22:49 GMT

Hi David,

Could you post your script.?

Re: Input Max value to field

Anonymous — Mon, 30 May 2016 06:28:17 GMT

I add the script, you can see the yellow at the bottom have a value but i want them every reload reset and have the max value of the fields.

Re: Input Max value to field

tamilarasu — Mon, 30 May 2016 06:39:57 GMT

Do you want to store the max value based on country or all the fields.?

Try like below,

......

NoConcatenate

Temp:

Load COUNTRY_NAME,

Max( HADERA_YEAR_CONSUMPTION)

Resident QLIKVIEW_COAL_BASKET Group by COUNTRY_NAME;

LET Vvalue= Peek('HADERA_YEAR_CONSUMPTION',0,'Temp');

DROP Table Temp;

EXIT SCRIPT;

Re: Input Max value to field

maniram23 — Mon, 30 May 2016 06:51:10 GMT

Hi,

Please find out attached file.

I think it help full for you..

Re: Input Max value to field

tamilarasu — Mon, 30 May 2016 06:56:43 GMT

If you want only max value for the field 'HADERA_YEAR_CONSUMPTION' irrespective of specific fields, you can try like below.

NoConcatenate

Temp:

Load Max( HADERA_YEAR_CONSUMPTION)

Resident QLIKVIEW_COAL_BASKET;

LET Vvalue= Peek('HADERA_YEAR_CONSUMPTION',0,'Temp');

DROP Table Temp;

EXIT SCRIPT;

Re: Input Max value to field

Anonymous — Mon, 30 May 2016 07:11:58 GMT

Thank you this was very helpful

Re: Input Max value to field

tamilarasu — Mon, 30 May 2016 08:26:37 GMT

Please note that peek function will not be picked the max value.