topic Re: Conditional Text Box Expression in QlikView

Conditional Text Box Expression

Fri, 20 Jul 2012 14:48:23 GMT

I have a conditional text box with the following condition expression:

=isnull(SubStringCount(GetFieldSelections(ShipmentID,';',63),vShip)) and isnum(num(vShip))

The text that appears within the box uses the following expression:

='**Shipment ID(s) Not Found : '&vShip&'

This text box is supposed to show up only when the value entered into the input box is not found in the data. However, the input box is designed to have multiple values pasted in to it from an Excel file. Therefore, some of the values may be found and some may not. Is there a way to get my text box to show up when any part of the search input is not found within the data field? The data inputs may be diffent characters in length, but will always be separated by a space, a comma, or an enter. Also, the text box needs to show which piece of the searcgh string was null and return that as text. I have attached an example of what I have so far.

All help will be greatly appreciated. Thanks!!

Re: Conditional Text Box Expression

brenner_martina — Fri, 20 Jul 2012 15:44:30 GMT

Hi,

I entered a new variable with Concat, and used this with the function Match(). Please look at your QVW.

Greetings from Munich

Martina

Re: Conditional Text Box Expression

Fri, 20 Jul 2012 16:02:19 GMT

I couldn't get it to work. Try pasting in the following values:

12345

12346

100

It should return the first two values because they are valid, but the red box should appear and say: "Shipment ID(s) Not Found: 100". I'm not sure this is even possible, but you may be on the right track with match. Thanks!

Re: Conditional Text Box Expression

Oleg_Troyansky — Sat, 21 Jul 2012 04:03:48 GMT

If the number of shipments in the list can be limited, you could replicate the same formula for a number of components, using function subfield()... It's hard to do anything so complex that could check any number of components, without running a loop... The perfect solution can be developed using a macro, but then you are running into all the disadvantages of the macros...

Re: Conditional Text Box Expression

brenner_martina — Mon, 23 Jul 2012 07:37:00 GMT

My TestQVW does work, I entered a new text box, I did not use yous! If I enter any No not in the list, it appears!

greetings

Martina