topic Min max values in QlikView

Min max values

vijetas42 — Wed, 19 Sep 2018 12:22:43 GMT

Hi Team,

I have data like,

DATE	Value
20151030	-3.3
20151106	-3.2
20151113	-3.2
20151120	-3.1
20151127	-3.1

from this data i want to show min, max value in textboxes and also date associated to them.If two different date ave same value then it should show recent date.

Regards,

Vijeta

Re: Min max values

Anonymous — Wed, 19 Sep 2018 12:36:04 GMT

I made a short sample with your data in an Inline table (I get string for values)

In TextBox i give Expression (in your case you should use max/min for values as they will be numbers)

='Val ' & MaxString(Value) & ' Date ' & max({<Value={'$(=MaxString(Value))'}>}DATE)
& chr(10)
& 'Val ' & MinString(Value) & ' Date ' & max({<Value={'$(=MinString(Value))'}>}DATE)

Re: Min max values

vishsaggi — Wed, 19 Sep 2018 13:10:40 GMT

Another way is

= 'Date: ' & Max(Aggr(Firstsortedvalue(DATE, Value), DATE)) & ' Val: ' &Max(Aggr(Firstsortedvalue(Value, -Value), DATE)) & Chr(13)&

'Date: ' & Min(Aggr(Firstsortedvalue(DATE, -Value), DATE)) & ' Val: ' &Min(Aggr(Firstsortedvalue(Value, -Value), DATE))

Re: Min max values

vijetas42 — Wed, 19 Sep 2018 13:54:34 GMT

my dates will be varying, if i select particular date then it takes last 8 weeks date and their values and if i try with your expression like,

=max(Aggr(Firstsortedvalue({<DATE={">=$(vPrior8WeekDate)<=$(vCurrentDate)"},NAME={'ALP'}>}VALUE,-VALUE),DATE))

but, it's giving some wrong value same case with min it's giving same as returning for max that too both are incorrect.

Re: Min max values

vishsaggi — Wed, 19 Sep 2018 14:17:20 GMT

Can you share some sample data you are trying this will be easy to test and work on. Based on the sample provided we gave you the option, quite did not get this date range can you show with an example and your expected output?

Re: Min max values

Gopi_E — Wed, 19 Sep 2018 14:46:58 GMT

Hi Vijetha,

try like this

='Min Val : ' & min(Value) & ' and ' & 'Date :'& Date(date#(Min(Aggr(FirstSortedValue(Date,-Date),Value)),'YYYYMMDD'),'MM-DD-YYYY')& chr(13) &

'Max Val : ' & max(Value) & ' and ' & 'Date :' & Date(date#(Max(Aggr(FirstSortedValue(Date,-Date),Value)),'YYYYMMDD'),'MM-DD-YYYY')

Regards,

Gopi