topic Re: Find min and max value in QlikView

Find min and max value

Anonymous — Mon, 07 Apr 2014 09:55:59 GMT

Hi,

in a table I will find min/max value of GJ_Woche. In textboxes are the min/max values, but how can I get GJ_Woche of min/max and what’s wrong on textbox Rows. There is not the correct NoOfRows?

Regards
Stefan

Re: Find min and max value

MK_QSL — Mon, 07 Apr 2014 10:03:55 GMT

Use script as below

TEST:

LOAD *, RowNo() as NO Inline [

GJ_Woche, Erloes

2010/01, 1.348

2010/02, 2.854

2010/03, 2.933

2010/04, 2.299

2010/05, 2.775

2010/06, 2.933

2010/07, 4.598

2010/08, 2.141

];

For No of rows in Text Box

= 'Rows ' & Max(NO)

Re: Find min and max value

tresB — Mon, 07 Apr 2014 10:10:53 GMT

Or, you can try :

= 'Rows ' & Aggr(NoOfRows(),GJ_Woche)

Re: Find min and max value

er_mohit — Mon, 07 Apr 2014 10:16:36 GMT

try this in object

='Total Rows' & aggr(noofrows(),GJ_Woche)

Re: Find min and max value

Anonymous — Mon, 07 Apr 2014 10:27:25 GMT

Hi Stefan

you can use 'count' function insted of 'NoOfRows'

= 'Rows ' & Count (GJ_Woche)

Regards

Harsha