Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted
Creator II
Creator II

Hi. try this,


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


Best reguards