I have a model which has a date selection, i.e. 201402.
I have an inline load which gives the user the option to choose from current Movement, YTD or Closing Balance.
When the user selects YTD for instance, the set analysis works out totals based on variables which are derived from the currently selected date.
The problem is that the user then wants to see detailed transactions for that date range, without the date range being selected. The transactions, which are in a flat table will only show for the selected date, even though the graph shows YTD.
I was hoping to create a trigger on change of the field which lists the option for YTD, Movement and Closing Balance, so that if the user selects YTD, it will automatically select all dates up to the selected date for the current year.
Unfortunately I don't know how one would build a macro for this and I don't know of any other way to do this.
All this can be done without macros, just use the functionality of QlikView charts to display the data at the summarised YTD level in one chart and at the detail of the transactions that are being totalled for the YTD figures in another chart, just add the necessary dimensions to view the detail.
I agree about avoiding macro's, but this one can't be done without it. I don't have time to set up a sample now to show you, but I've also tried to explain it in every way. But thanks for the effort guys.
