Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear experts,
Please help me out.
I want to add a text box in my dashboard. The textbox only needs to pop up when a certain demension is not selected.
In this case the tab contains detailed information about orders and I want the Text box to say "Please select ordernumber".
Otherwise the data will not be relevant.
How to do this?
Try this on the conditional display option:
GetSelectedCount(orderNumber)=0
Use like in your textbox layout tab conditional option
= IF(GetSelectedCount(orderNumber) = 0, 1, 0)
Try this on the conditional display option:
GetSelectedCount(orderNumber)=0
In the layout properties of the text object write
=GetSelectedCount(OrderNo _Field)=0
Or else, you could use a Calculation condition in your chart objects or table boxes, with almost the same expression as suggested before (but inverted). The advantage is that a calculation condition will block chart objects from doing time-and-energy consuming work as long as no OrderNumber is selected.
For example, open Properties->General and add the following expression in the "Calculation Condition" field:
GetSelectedCount(OrderNumber) = 1
Then click the Error Messages... button at the bottom, navigate down in the list and select the entry called "Calculation condition unfulfilled". Enter a descriptive text in the Custom Message field that explains why you're not showing any data yet. This message will be displayed on the empty background of your Straight table.
Note that simpler objects have no such feature.
Thank you all. Solved the problem