topic Re: Current Week, Month, Year default Setup in QlikView

Current Week, Month, Year default Setup

ksomosera10 — Fri, 08 Sep 2017 02:28:24 GMT

Hi Everyone,

I have a question. I'm have a 2 sheets with many visualization and customized values on Qlikview app. I'm having some trouble on showing the whole idea of my design because each run, I always have the whole values of 5 years and its causing a hard time when I filter it one-by-one just to show what I had in mind. Is there a way that each run of my dashboard, the current week, month, year will always be the default apperance? or it will always be the default filtering? it will just move once the user will change the ranges of these parameter.

I hope you'll help me out here.

Thanks!

Re: Current Week, Month, Year default Setup

Anil_Babu_Samineni — Fri, 08 Sep 2017 02:35:15 GMT

Yes, You could use OnOpen Trigger to each like below

Week == Max(Week)

Month == Max(Month)

Year == Max(Year)

Re: Current Week, Month, Year default Setup

ksomosera10 — Fri, 08 Sep 2017 02:57:55 GMT

Hi Anil,

Thanks for answering, I have a question. I've tried that but unfortunately It only captures 1 filtering.

Do you think I missed something?

here's what happened on the selection.

I hope you can help me out here. Thanks!

Re: Current Week, Month, Year default Setup

Anil_Babu_Samineni — Fri, 08 Sep 2017 03:04:14 GMT

Off course, Because we are using action only picks the Max value. This is where i was explaining to you..

Is there a way that each run of my dashboard, the current week, month, year will always be the default apperance?

Re: Current Week, Month, Year default Setup

ksomosera10 — Fri, 08 Sep 2017 03:09:34 GMT

Do you have any suggestions on what should I do?

Re: Current Week, Month, Year default Setup

Anil_Babu_Samineni — Fri, 08 Sep 2017 03:22:42 GMT

Off course, You can check remain 2 actions as well. Because, i have done sample it's working

PFA

Note - I would ask you to mark as helpful and if your solution resolved then close this thread by flag correct answer