topic QlikSense Default Month and year selection in App Development

QlikSense Default Month and year selection

vardhancse — Sat, 16 Nov 2024 06:26:41 GMT

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

NhanNguyen — Mon, 04 Mar 2019 06:35:05 GMT

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

vardhancse — Mon, 04 Mar 2019 06:41:07 GMT

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 — Mon, 04 Mar 2019 07:18:53 GMT

What do you mean by logic to apply those variables?

vardhancse — Mon, 04 Mar 2019 08:40:30 GMT

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 — Mon, 04 Mar 2019 08:42:34 GMT

Hi vardhancse,

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

@ChristofSchwarz has a very good solution for this.

Hope it helps,

vardhancse — Mon, 04 Mar 2019 08:50:42 GMT

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 😞