firstsortedvalue with set Analysis

Tue, 17 May 2011 15:43:49 GMT

Dear all

i need your help for a firstsortedvalue function with set analysis.

Goals:

extract the max date for the records that are between two imput date

Situation :

CODE	ESITO	STATUS	LEVEL	DESCR	DATE
3660	Poor	C	PR3.3	Audit	10/09/2007
3660		C	PR3.1	Awareness Program	20/05/2008
3660	Good	C	PR3.3	Audit	09/09/2008

VarDataFrom = 01/01/2004

VarDataTo = 31/12/2007

Expression:

firstsortedvalue( {$<SUPERVIS.DateCreatedokNum={">=$(#VarDataFrom), <=$(#VarDataTo)"}>}

SUPERVISION.DateCreatedokNum,-SUPERVISION.DateCreatedokNum)

the chart extract always the last date (09/09/2008) regardless the two input variables.

Please help me.

Best Regards

Riccardo

Re: firstsortedvalue with set Analysis

Tue, 17 May 2011 15:54:07 GMT

Hi,

the reason is the comma in the set analysis. It is an "inclusive or", which means that the date is either bigger than VarDataFrom or smaller than VarDataTo.

Therefore the right formula is

firstsortedvalue( {$<SUPERVIS.DateCreatedokNum={">=$(#VarDataFrom)<=$(#VarDataTo)"}>}

SUPERVISION.DateCreatedokNum,-SUPERVISION.DateCreatedokNum)

See the textbox in the attached qvw for more information.

Cheers,

Gerald

topic firstsortedvalue with set Analysis in QlikView

firstsortedvalue with set Analysis

Re: firstsortedvalue with set Analysis