How to restrict QV to show only desired data?

[soha1902]

Hi all,

I have previous years of data as well as 2 year of forecast data.

Now my requairement is when I open my QV application by default it will show only 11 month data. from current to next 11 month.

How will I achieve this.

Thanks in Advace

[Gysbert_Wassenaar]

Use the OnOpen document trigger to make the necessary selection (or create a bookmark first and activate that bookmark).

[#3]

Do you want this for whole document itself? Then you go for what Gysbert adviced.

If you want it for particular object, then that we can achive by set analysis as well.

[soha1902]

I want to make selection from current month to next 11 month to all the sheet objects. what changes need to be done on open document trigger?

[#5]

The other way you can do is, that you must be having a Data Key linked to your fact table. So on open document trigger, use the "Select in Field" trigger to select the dates from today till next 11 months.

Can you attach your sample app, this will help community members to give quick responses.

Thanks,

Angad

[sunilkumarqv]

Hi

Firstly make selections from current month and up to next 11 months  apply bookmark and name it BM.

then go document properties select triggers on Docment Event Triggers Onopen add actions add action type :Bookmark ,Action : Apply Bookmark.

That is how things are done .