Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlikers,
Please I need your help. I am working on a Dashboard which currently displays the datasets for all the months but I only want the current month/Year to display by default.
I have also attached the format of the date column below.
Please help me. Thanks in advance.
Nick.
Hello,
You can write set analysis for each visualization to show only current year/month.
e.g Sum({<Year = {"$(=Max(Year))"}>}Sales)
//This expression will only show the data for max year by default and will show data accordingly on selection.
You can learn more about set analysis on below Qlik help site.
Thanks,
Ashutosh
Thanks Ashutosh! Set analysis didnt give me what I wanted. I finally settled for Bookmarks. Just that with Bookmarks, the App has to be edited each month.
Great.
You can dynamic the bookmark to show the max year/month by using below set.
Year={"=Year=Year(Today())"}>}
Write above set in filterpane and create a bookmark. Set it as a default bookmark for on open selection.
Thanks,
Ashutosh