topic Re: auto select this month and last month on open.... in QlikView

auto select this month and last month on open....

Anonymous — Tue, 04 Sep 2018 20:34:19 GMT

I have a date field (CallDateMonthYear) that displays as 'MMM-YYYY'. On opening, I want to auto select this month (for example Sep-2018) and LAST month (Aug-2018). I've tried a few different things and am totally lost. Suggestions??

Re: auto select this month and last month on open....

swuehl — Tue, 04 Sep 2018 21:15:35 GMT

You can try an OnOpen trigger under Settings - Document properties - Triggers with a Selection - Select in field action:

='('&Date(Today(),'MMM-YYYY')&'|'&Date(Addmonths(Today(),-1),'MMM-YYYY')&')'

Re: auto select this month and last month on open....

Anonymous — Tue, 04 Sep 2018 22:42:08 GMT

Worked! Thank you!

Re: auto select this month and last month on open....

Anonymous — Wed, 05 Sep 2018 00:54:57 GMT

So. Going back to the well one more time...I have another field that gives me week ending dates and they are formatted 09/08/2018 for example. I tried the same concept but to select that field using this:

='('&Date(WeekEnd(Today(),-1),'MM/DD/YYYY')&'|'&Date(WeekEnd(Today(),-2),'MM/DD/YYYY')&')'

but it DOES NOT work for some reason. I put this in a text box to see if it was giving me the right results and it did (the expression you provided which is working as expected to limit the results to current and previous month is in the bottom text box and the expression above is in the top text box:

But when I do the exact same steps to put that as the search string for selecting the other field (CallDateWeekYear) it only shows the FIRST week in that range and not both. Since partial weeks are giving numbers that distort trend lines, I'm going for last full week and the full week prior to that...

Re: auto select this month and last month on open....

swuehl — Wed, 05 Sep 2018 15:57:40 GMT

Do you have any other selections present when applying that action?