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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Marius_
Contributor III
Contributor III

Ignore all but 1 selection in set analysis

For this data set

I want to return The maximum "Tonne" =[10] for each line

Marius__0-1662026324251.png

 

 

I tried the following:

Max({<[DocType]=,[Condition type]=,[SubDoc]=>}Quantity)

So for each Contract I am looking to return the max quantity => on each line [So every line must return 10]

 

 

 

Labels (1)
1 Reply
marcus_sommer

It looked that you didn't want to ignore selections else the dimensionality within the table. This could be reached with TOTAL like: max(TOTAL Quantity) or maybe max(TOTAL <Dim1, Dim2> Quantity) whereby Dim1 + Dim2 are just place-holder for dimensions which should be further respected.

- Marcus