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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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