topic Re: Show message 'No data to display' in QlikView

Show message 'No data to display'

Mon, 18 Feb 2013 15:29:21 GMT

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.

Re: Show message 'No data to display'

Gysbert_Wassenaar — Mon, 18 Feb 2013 15:34:49 GMT

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.

Re: Show message 'No data to display'

Tue, 19 Feb 2013 09:50:26 GMT

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!