Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I wanted to show last 12 months data when QV application is loaded. I think if the last 12 yearMonth can be selected when application is loaded, it will solve my problem. So my question is how I can pre-select the last 12 or n items in the list box. My YearMonth listbox like below. Can this be done? Thanks
201201 |
201202 |
201203 |
201204 |
201205 |
201206 |
201207 |
201208 |
201209 |
201210 |
201211 |
201212 |
201301 |
201302 |
201303 |
201304 |
201305 |
201306 |
201307 |
201308 |
201309 |
201310 |
201311 |
201312 |
201401 |
You said in your original post, "I think if the last 12 yearMonth can be selected when application is loaded." I took that as meaning you wanted them selected when the application was reloaded. If you meant you want them selected when the application is opened, you need to use the following instead:
Settings > Document Properties > Triggers > On Open > Add Actions > Selection > Select in Field
Field:
YearMonth
Search String:
='>='&max(YearMonth,12)
Example file also attached.
Settings > Document Properties > Triggers > On Post Reload > Add Actions > Selection > Select in Field
Field:
YearMonth
Search String:
='>='&max(YearMonth,12)
Example file also attached.
Thank you for you quick response. Your example works just fine, but I cannot get it done by following your instruction. I will continue working on it and let you know.
Here is the sample I created using your data, but it did not work. Please find my file in attachment. Something is missing from my side.
The example Nicole showed works. However you have to keep in mind that because the trigger is applied as an OnPostReload, preselections will only occur after you Reload the document at least once. You can also set the trigger at sheet level with a onActivate/onleave sheet event (Settings > Sheet properties > triggers, so you don't have to wait until reload to see the selections take effect,
regards
You said in your original post, "I think if the last 12 yearMonth can be selected when application is loaded." I took that as meaning you wanted them selected when the application was reloaded. If you meant you want them selected when the application is opened, you need to use the following instead:
Settings > Document Properties > Triggers > On Open > Add Actions > Selection > Select in Field
Field:
YearMonth
Search String:
='>='&max(YearMonth,12)
Example file also attached.
Is there any way only last 12 months data will be displayed in the chart? This solution works fine when application is first loaded. Obviously it is not an ideal solution. Do you have any ideas? Thanks
Set analysis in your expression like the following should work for that:
{<YearMonth={'>=$(=max({1}YearMonth,12))<=$(=max({1}YearMonth))'}>}
So your expression would look like:
sum({<YearMonth={'>=$(=max({1}YearMonth,12))<=$(=max({1}YearMonth))'}>}Value)
Example file is attached.
Qlikview is so powerful and you are the genius. Thanks