Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

stefan_fischer
New Contributor II

Find min and max value

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

4 Replies

Re: Find min and max value

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)

MVP
MVP

Re: Find min and max value

Or, you can try :

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

er_mohit
Honored Contributor II

Re: Find min and max value

try this in object

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

sriharsha96
Contributor II

Re: Find min and max value

Hi Stefan

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

 

= 'Rows ' & Count (GJ_Woche)

Regards

Harsha

Community Browser