Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to make get a max value independent of selection.

Hi Friends,

I am using this line of code to get the max number of YearMonth. Right now it depends on the selection of the data and this causes some problems. I really wanted to make this only depend upon selected Metrics, selected Intervention but nothing else. How can I do it?

'Max({<'& only(%Metrics) & '={1}, ' & only(%Intervention) & '={0}>}YearMonth)'

Thanks.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: How to make get a max value independent of selection.

Try with this:

Max({1< %Metrics={1}, %Intervention={0} >} YearMonth)

1 Reply
Not applicable

Re: How to make get a max value independent of selection.

Try with this:

Max({1< %Metrics={1}, %Intervention={0} >} YearMonth)

Community Browser