Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

QlikSense Default Month and year selection

Hi,

I have a requirement like, by default month and year selections need to be applied.

for an instance:

E.g 1:

Current Year: 2019 & Current Month: March

Required Filter: Year: 2019 & Month: February

E.g 2:

Current Year: 2019 & Month: January

Required Filter: Year: 2018 & Month: December

can some one please let me know any suggestions.

I have N number of expressions and every thing need to be done based out of that

Labels (3)
6 Replies
NhanNguyen
Contributor III
Contributor III

How about creating 4 variables: CurrentYear, CurrentMonth, FilterYear, FilterMonth. Then, you could use them dynamically in your expressions. 

vardhancse
Specialist III
Specialist III
Author

Thank you, I have created variables and plan to use them in my expression.

But got struck with logic's need to apply in that respective variables.

If you have some working logic's can let me know so that I can give a try

NhanNguyen
Contributor III
Contributor III

What do you mean by logic to apply those variables?

vardhancse
Specialist III
Specialist III
Author

Like, my requirement is something mentioned below"

current month: March & Year: 2019

By default filter(to be applied):

Month: February & Year: 2019 (current month -1, because the report what we are doing is for previous month)

Previous to Previous Metric/KPI: Month: January & Year: 2019(I have one more metric, it should show previous to previous month and year value)

kaanerisen
Creator III
Creator III

Hi vardhancse,

You can use "default bookmark selection" option to achieve it. 

@ChristofSchwarz  has a very good solution for this.

https://www.youtube.com/watch?v=d85WIgy35Ig

Hope it helps,

vardhancse
Specialist III
Specialist III
Author

Thank you and its very much helpful, but unfortunately Its a enhancement  and was only available for QS September 2018 edition/release.

Our version is not Sep 2018 😞