Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hansrokers
Contributor III
Contributor III

max i.s.o. sum in set analysis

In a straight tabel I have the field INVOICEDATE as the dimension.

In the expression I have max({1} INVOICEDATE)

I would expect always the highest date in the expression but is showing the dimension date.

When I create a textbox with =max({1} INVOICEDATE) it is showing the highest date, even when putting a filter on INVOICEDATE.

What am I doing wrong?

1 Solution

Accepted Solutions
marcus_sommer

Try: max({1} TOTAL INVOICEDATE)


- Marcus

View solution in original post

3 Replies
marcus_sommer

Try: max({1} TOTAL INVOICEDATE)


- Marcus

swuehl
MVP
MVP

You need to calculate your expression in total context:

=Max({1} TOTAL INVOICEDATE)

tresesco
MVP
MVP

Try:

max( Total {1} INVOICEDATE)