Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
zagzebski
Contributor

Getting Max Date in text box (and unaffected by filtering)

I have the following expression in text box:

=max(date([Date Loaded GL],'MMMM  DD YYYY'))

Works fine but want it so no matter what is filtered it continues to give me the max date. Currently if certain fields are filtered on it wipes out the date due to how my model is set up.

Thanks in advance,

Zag

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Getting Max Date in text box (and unaffected by filtering)

use set Analysis to ignore some fields or all

ignore all selections: =max({1}date([Date Loaded GL],'MMMM  DD YYYY'))

ignore some fields sselections: =max({<Field1=,Field2=>}date([Date Loaded GL],'MMMM  DD YYYY'))

  define as many fields as you want to ignore

View solution in original post

3 Replies
Partner
Partner

Re: Getting Max Date in text box (and unaffected by filtering)

use set Analysis to ignore some fields or all

ignore all selections: =max({1}date([Date Loaded GL],'MMMM  DD YYYY'))

ignore some fields sselections: =max({<Field1=,Field2=>}date([Date Loaded GL],'MMMM  DD YYYY'))

  define as many fields as you want to ignore

View solution in original post

Re: Getting Max Date in text box (and unaffected by filtering)

Try the reverse order of date and max function and to ignore selections use {1} in the set analysis:

=Date(Max({1}[Date Loaded GL]), 'MMMM DD YYYY')

zagzebski
Contributor

Re: Getting Max Date in text box (and unaffected by filtering)

THanks!