Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Set analysis comparing the Max() of a data?

Hello everyone, I have 2 questions regardind data inside Qlik Sense: 

1 - I'm working in a dashboard where I need to show the user the latest KPIs of a group of fields to the users.

The point is I'm unable to compare or retrieve other fields, I think the expression would be something like the example below:

${<Max([Status Date])>}[Current Status]

2 - Furthermore, I'd like to allow the user to change the [Status Date] and see the [Current Status] according to the date he selected.

I tried to do this using the bi-era.com_listbot object which allow me to set default value.

Thanks in advance.

1 Reply
Contributor II

Re: Set analysis comparing the Max() of a data?

Hi. try this,

Sum({<[Status Date] = {$(=Max([Status Date]))} >} [Current Status])

Best reguards