topic Re: problem in QlikView

problem

Mon, 22 Dec 2014 09:13:55 GMT

how to calculate the max of this kind of number

Re: problem

its_anandrjs — Mon, 22 Dec 2014 09:16:48 GMT

Hi,

Did you try

=Max(COEP_Key)

Regards

Anand

Re: problem

anbu1984 — Mon, 22 Dec 2014 09:17:08 GMT

You can try MaxString()

Re: problem

Gysbert_Wassenaar — Mon, 22 Dec 2014 09:20:12 GMT

Those are text values. You can try using the maxstring function: maxstring(COEP_Key). But if those values should be numbers then use the num# value in the script to cast the text values to numeric values: num#(COE_Key) as COE_Key

Re: problem

its_anandrjs — Mon, 22 Dec 2014 09:21:36 GMT

You can try some of this

=Max( Num(COEP_Key) )
Or
=Max( Num#(COEP_Key) )
Or
=Maxstring( Text (COEP_Key) )
Or
=Maxstring( COEP_Key )

Regards

Anand

Re: problem

Mon, 22 Dec 2014 09:41:22 GMT

I already applied num# ,but the number remain in string format,

This is the field of COEP table of SAP ,i have to apply increamental load on the basis of primary ,for that i need coep_key

Re: problem

tyagishaila — Mon, 22 Dec 2014 10:16:20 GMT

You can use Statistics Box for the field, for which you want to find max value.

Re: problem

Sat, 27 Dec 2014 06:48:22 GMT

if i do that this single table more than 2 hrs to relaod

Re: problem

Sat, 27 Dec 2014 06:53:22 GMT

Hey Anand,

Maxstring asd Maxstring text functional ,but is it a good practice to use maxstring functional while implementing incremental load in order to find new records.

Re: problem

Sat, 27 Dec 2014 06:53:49 GMT

i want to implement it in backend

Re: problem

SunilChauhan — Sat, 27 Dec 2014 14:33:46 GMT

COEP:

Load COEP_Key

from path

MaxCOEP:

Load COEP_Key,

Max( Num#(COEP_Key) ) as maxCOEP_Key

resident COEP;

hope this helps