Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm just moving to QlikSense from Tableau but I need to create a "dynamic date/parameter date", I'm using my date like a filter but I need to show the data from the last date of my date filter selection for only one of my columns, for example:
Date Filter The one column All the other data
09/28/21 09/27/21 09/28/21
09/29/21 09/28/21 09/29/21
09/30/21 09/29/21 09/30/21
Is that possible? Could you support me?
Regards!!!
Maybe I'm forgetting a ")", but the set analysis shows an error
I modified the expression to: count( {< [date_search] = {'$(=date(max([date_search]) - 1))'}>}[value_calculate]) and now it's working!
Thank you so much @stevejoyce !!!
Best regards!
What is the purpose of the dollar & equals sign within the sum( {< [My date filter] = {'$(=date(max([My date filter]) - 1)'} >} sales) set analysis expression? Does it cause the date function to become a dynamic function? Also, what resources did you use to learn about these expressions? Thanks.