Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to gert maximum records only in graph
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 .???
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
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: