Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nick36
Contributor II
Contributor II

How to display current month by default in Qliksense?

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.

3 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

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.

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnal...

 

Thanks,

Ashutosh

 

Nick36
Contributor II
Contributor II
Author

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.

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

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