topic Conditional Show Using Multiple Options for Text Object in QlikView

Conditional Show Using Multiple Options for Text Object

Thu, 15 Aug 2013 17:19:06 GMT

I have a text box covering a table that without selections made is too large and displays the error message, "Out of object memory". So I'm forcing users to narrow the data retrieval. Once they've made the required selections the text box disappears off of the table.

Users must select a Well_Prospect AND a Well_Pad ...... OR .......must select a Well_Name

I can get the below to work as individuals on the text box in the Layout Properties.

(GetSelectedCount(Well_Prospect) < 1) + (GetSelectedCount(Well_Pad) < 1) ... works

(GetSelectedCount(Well_Name) < 1) ... works

How do I combine the two correctly?

(GetSelectedCount(Well_Name) < 1) or ((GetSelectedCount(Well_Prospect) < 1) + (GetSelectedCount(Well_Pad) < 1)) ... does not work

Thanks.

Re: Conditional Show Using Multiple Options for Text Object

Oleg_Troyansky — Thu, 15 Aug 2013 19:44:40 GMT

First, I'd recommend doing the same, using a "Calculation Condition" and a custom Error Message.

You can formulate a condition that needs to be fulfilled, before the chart gets calculated - this way, the chart won't have to work hard before going "Out of Memory". Then, you can replace the default Error Message "Calculation Condition unfulfilled with a more user friendly message, like "Please select a Prospect and a Pad and ...".

So, this eliminates the need in the extra text object.

Now, in order to formulate your condition, you need to use keywords "and" / "or", to simplify your condition. For example:

(GetSelectedCount(Well_Name) < 1) or ((GetSelectedCount(Well_Prospect) < 1) and (GetSelectedCount(Well_Pad) < 1))

cheers,

Oleg Troyansky