topic Re: Conditional Text box in QlikView

Conditional Text box

tomgrouwe — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Conditional Text box

vishsaggi — Fri, 15 Dec 2017 13:11:19 GMT

Use like in your textbox layout tab conditional option

= IF(GetSelectedCount(orderNumber) = 0, 1, 0)

Re: Conditional Text box

YoussefBelloum — Fri, 15 Dec 2017 13:19:11 GMT

Try this on the conditional display option:

GetSelectedCount(orderNumber)=0

Re: Conditional Text box

its_anandrjs — Fri, 15 Dec 2017 13:29:54 GMT

In the layout properties of the text object write

=GetSelectedCount(OrderNo _Field)=0

Re: Conditional Text box

Peter_Cammaert — Fri, 15 Dec 2017 13:30:27 GMT

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.

Re: Conditional Text box

tomgrouwe — Fri, 15 Dec 2017 14:15:48 GMT

Thank you all. Solved the problem