Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

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
Creator II
Creator II

Hi. try this,

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

Best reguards