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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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, ....))