We need to filter the records for a indivudal sheet alone.
We have almost 10 sheets in the qvw file. All of the sheets uses a query which would return 10 years of data. from 2000, 2001, 2002....2010.
But for just one sheet we would need to have the current year records alone.
these sheets are basically charts which have the time dimension on the x-axis. So for only 1 sheet we would need just the 2010 data. whch would be having the months jan, feb. mar....dec just for the currrent year 2010.
We can do this from the Edit script menu where in we can add a seprate Query and build new Column names which can be reffered in the current year Sheet.
But we wuold not prefer this as it would create columns with Similar column names. is there a way by which we can filter reords in the sheet level.
You could solve this by creating a different set of data for the objects on the sheet by using SET ANALYSIS. I did a similar thing for an application that had a sheet in it, that overwrites the selections made in other sheets, without changing them.
Your expression would be something like:
=sum({$<Year = {2010}> Sales)
for a sales figure, that only has 2010 data in it, while this is not selected. In my case, I had to make sure to include all months of 2010, so I had to ignore selections made elsewhere in the app like this:
=sum({1<Year = {2010}, Month= > Sales)
Note the $ changing into 1, see help for this. If possible, create a variable that holds the set and apply that to all the expressions, as these sets tend to get quite complex (depending on the number of values in the selection you have to change).
There is an excellent example called "Set Analysis - Comparing Selections.qvw" (which I cannot find at the moment, sorry)
I was able to create a trigger on Sheet event trigger. I used OnActivatesheet to select the Field value (2010) in the selection. It works well. When i moved to sheet, it triggered and field 2010 was selected.
But when i move to other sheets, where i havent set any triggers, i want to unselect 2010 for the Date field. I was not able to find Clear field option. Instead there were Clear Other Fields and Clear All.
Is thee any way to unselect a particluar field alone.
I'm not quiete sure what you want, but is there a way to get an extra field in your dataset that only holds the year (so you can select on YEAR and on PERIOD_ID), this would probably be the easiest way...
You could also use $<PERIOD_ID={2010*}> this is valid according to the QV Reference Manual (Part III, page 353 and up)
