Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am new to Qlik sense, I have a filter in my dashboard named "FiscalYear" having values like FY23, FY24, etc. I want to select the latest FiscalYear value by default every time the dashboard loads. The user can also select multiple values from the filter and deselect the default selected value.
I was trying to implement this by using the bookmark method but I am unable to find the exact field expression to be applied in the filter so that it will always select the latest FiscalYear.
I have tried Max, Maxstring but non of them worked. Can someone please help me with this?
If there are any alternative or more efficient ways to do this then please suggest.
Qlik Sense Desktop Qlik Sense Business
Try this as your search expression (including the surrounding curly brackets):
{<"=FiscalYear"={"=FiscalYear="$(=maxstring({1}FiscalYear))"}>}
Hi @henrikalmen,
Thank you for your reply, I tried the expression but not getting any match in the search field.
Do I need to add anything else here?
No, you're right. When experimenting I can't get it to work with a text field. Perhaps you could make it a numeric field instead, using dual(). I have done this with numeric fields, so I know it should work then.
Actually it's a requirement that I need to get the latest FY value from this string data type only, not allowed to change it to numeric data type.
Can you add a flag in your data model so that you have a new field next to FiscalYear, named e.g. latestFiscalYear and set it to 1 for the latest FiscalYear? If so you could do this search in the FiscalYear field:
=[latestFiscalYear]=1