Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about creating 4 variables: CurrentYear, CurrentMonth, FilterYear, FilterMonth. Then, you could use them dynamically in your expressions.
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
What do you mean by logic to apply those variables?
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)
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,
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 😞