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: 
microwin88x
Creator III
Creator III

Expression2 =MAX(Expression1)?

Hello!

I wanted to know if it is possible to have 2 expressions, where the 2nd expression is a MAX from the 1st expression.

Could that be possible?

Thank you!!!

3 Replies
MK_QSL
MVP
MVP

Can you share your sample data or sample apps?

You can do it like below

Expression2 = Max(TOTAL Expression1)

its_anandrjs
Champion III
Champion III

Yes may be it will write like

If( Expressssion2 = Max(Expression1, True ExecuteStatement1, False ExecuteStatement2 )

And

IF(Sum(Expression2) = Max(Expression1), Statement1,statement2)

tresesco
MVP
MVP

I guess you can try using AGGR() like:

Sum(Amt) = Max(Aggr(Sum(Amt) , Dimension1, ....))