Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to gert maximum records only

how to gert maximum records only in graph

3 Replies
sujeetsingh
Master III
Master III

Nishani ,

First i want to know the maximum defination  in your context.

What this maximum is maximum no. of records ,or the records with maximum value .???

er_mohit
Master II
Master II

use firstsortedvalue function in your expression side

like if i want maximum value on the basis of dateon corresponding product then write

firstsortedvalue(Value,-Date) // it gives you max. value for the product on basis of max date

hope it helps

Not applicable
Author

How many "max" values do you want to show? You have to define that in the object.

Are you using Qlikview 11 .  In qlikview 11 you do that like this:

sample.bmp