Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
lrdrogerio
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
giovanneb
Creator II
Creator II

Hi. try this,


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


Best reguards