Include+Exclude records from opening QVW

[#1]

I know how to do an ON-OPEN (with a bookmark) a QVW with to have all records where DIVISION <> 35.

How can I make a button  called '35' to include DIVISION=35 (for a current situation)?  This button will not disturb any current situation, but enhance it.

For example, if the current situation was for set to only Manager='John Smith' and Age < 30 , if '35' is clicked, it will keep all 'John Smith' records and APPEND Division=35 records for 'John Smith' who are Age < 30.

Thanks in advance.

No, when user opens this dashboard, all data is accessible except DIVISION=35. this means DIVISION=5,10,17,25,65 are available. User can then look at graphs, Etc, for all DIVISIONS except 35, and can also set other ‘Current Selections’ such as filter on Manager under current view (where DIVISION <> 35).

When User clicks on ‘35’ button,  extra DIVISION=35 records will show up on dashboard.

But, the extra DIVISION=35 records  are subject to the ‘Current Selections’.

If DIVISION=35 has NO Manager=’John Smith’ records, clicking on button will generate 0 records.

Does this clarify?

Hi,  Sample.qvw was close.  But, what if the User selects only DIVISION='05'.  Then, when click on '35', I would like to add on only 'DIVISION='05'.  Do I need to "access" the current selection for DIVISION? 

[MayilVahanan]

HI

If i understand your question correctly means, Try like this

Assign a variable named vDivision and assign zero . While click the button assign the value to variable as 35

And use expression

If(Manager = 'John Smith' and Age<30 and/or Division = vDivision, expression1, expresssion2)

Hope that helps

[MayilVahanan]

Hi

Did you ask like this? or hope that it may be bring in right direction