Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Am using QV11 SR12. I have around 30 charts in my report.
My requirement would be to display few charts to current month and the remaining to previous month.(OnLoad)
This should be implemented when the application is opened.(OnLoad).
Is this requirement possible with trigger or is there any alternate solution.
If so ,can anyone please help.Thanks.
There is a OnOpen Trigger, I am not sure if there is OnLoad Trigger you might be able to employ ReloadTime() function to trigger an event. And to set two different set of charts with different filters, you might be able to use alternate state for some of the charts that need to drive based on OnLoad trigger.
We might be able to help you better if you can prepare a small sample for us to help you better.
There is no OnLoad trigger, and the OnOpen trigger is not fired in the access point, so this will only work with Qlikview desktop.
A better way to do this is to design the expressions such that they produce the required output when no selection is made, and that they respond to selections when the selections are made.
For example,
Sum({<ReportDate = {"$(=Date(Max(ReportDate)))"}>} Sales)
will show the sales for the most recent day on file if nothing is selected, and will return sales for the selected date isa date is selected. You can put the expression =Date(Max(ReportDate))) into the caption or expression headers to show the user what date is being reported.