Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've two sheets in my dashboard, called 'Sales' and 'Orders' and one of the filters named 'Status' with the filteroptions 'Invoice' and 'Order'.
When you select the filteroption 'Invoice' or another selection which doesn't include any orders, I want to see in sheet 'Sales' only the invoicerecords of the selection. In sheet 'Orders' I want to see the message 'No data to display'.
The opposite if the filteroption is 'Order' or another selection which doesn't include any salesrecords. I want to see in sheet 'Orders' only the orderrecords of the selection. In sheet 'Sales' I want to see the message 'No data to display'.
When you leave one of the sheets I want the current selections stays active.
How do I achieve this?
For example
Filter = Invoice
Sheet Sales presents:
Article Invoicenumber Date Amount
Greens 1256 1-3-2012 1.245,-
Basil 5685 25-5-2013 500,-
When you click on sheet Orders you see the message:
No data to display
When you leave sheet 'Orders' the current selection of 'Invoice' stays active.
Thank you very much for your helpful answer! I've used a mix of your answer.
1. In the properties of the view in sheet 'Orders', tab 'Layout' I activated the Show Conditional with
if(Status='Invoice',0,1).
2. I've made a textbox with the text 'No data to display' and set the Show Conditional in the Layout tab to:
if(Status='Invoice',1,0).
When I have only selected invoices and I go to sheet 'Orders' I see now the desired message!
If you're using QV11 you can use conditional display expressions. Add two textboxes with your message and set the conditional expression to if(Status='Invoice',0,1) for the textbox on the Sales sheet and if(Status='Order',0,1) for the textbox on the Orders sheet. You can find the conditional option on the Layout tab of the properties window of the object.
Thank you very much for your helpful answer! I've used a mix of your answer.
1. In the properties of the view in sheet 'Orders', tab 'Layout' I activated the Show Conditional with
if(Status='Invoice',0,1).
2. I've made a textbox with the text 'No data to display' and set the Show Conditional in the Layout tab to:
if(Status='Invoice',1,0).
When I have only selected invoices and I go to sheet 'Orders' I see now the desired message!