Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
MK_QSL
MVP
MVP

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)

tresesco
MVP
MVP

Or, you can try :

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

er_mohit
Master II
Master II

try this in object

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

Anonymous
Not applicable
Author

Hi Stefan

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

 

= 'Rows ' & Count (GJ_Woche)

Regards

Harsha