Re: Only Display Most Recent Data in Dropdown - Qlik Community

danshanahan · ‎2021-02-18

Hey everyone. I'm trying to create a visualization expression which only displays fields that are from the most recent data set.

Here's an example of my data:

I'm wondering if there is a way to only return the business unit names from the most recent date? In this case, I would only display bu2 and bu3.

I've tried a set expression and FirstSortedValue([business unit], [updated at]), but neither worked.

Any thoughts? Thanks!

edwin · ‎2021-02-18

normally i would create a variable that holds the date:
vMaxDate = date(max([updated at]))

then in set analysis:
{<[updated at]={'$(vMaxDate)'}>}

hope that helps

Chanty4u · ‎2021-02-19

you can use

SET DateFormat='DD/MM/YYYY';

Dimension: ID

Expression : Date(max([updated at]))

agigliotti · ‎2021-02-19

You could use the below expression for your listbox.

=Aggr( if( [updated at] = date(max( total [updated at])), [business unit] ), [business unit] )

I hope it can help.

Best Regards

danshanahan · ‎2021-02-22

I was able to get this with a an aggregation and set expression:

=aggr(only({<uploaded_at = {"$(=Max(updated_at))"}>} business_unit),business_unit)

Thank everyone for the help!

Only Display Most Recent Data in Dropdown