topic Re: How to check if a value exist in a listbox in QlikView

How to check if a value exist in a listbox

Anonymous — Wed, 27 May 2015 13:54:24 GMT

Dear Community,

with an expression i simply want to check if a value exists inside a listbox.

How can this be done?

Example:

Data:

Load *,DepthSN As DepthSN_New Inline [

Producer, DepthSN

p1,aaa

p2,bbb

p3,ccc ];

How to check that the value 'aaa' exists inside 'Data'?

Re: How to check if a value exist in a listbox

sunny_talwar — Wed, 27 May 2015 13:59:36 GMT

You can use a expression like this in a list box:

=If(SubStringCount(Concat(DISTINCT DepthSN,'|'), 'aaa') = 1, 'aaa exists', 'aaa does not exist')

This will change results based on your selection. So for instance if you don't select 'aaa' in your list box it will say aaa does not exist. If you don't want that you can change the expression to this:

=If(SubStringCount(Concat({1}DISTINCT DepthSN,'|'), 'aaa') = 1, 'aaa exists', 'aaa does not exist')

HTH

Best,

Sunny

Re: How to check if a value exist in a listbox

Clever_Anjos — Wed, 27 May 2015 14:00:10 GMT

Count({<DepthSN ={"aaaa"}>} DepthSN ) > 0

Re: How to check if a value exist in a listbox

Anonymous — Wed, 27 May 2015 14:04:47 GMT

Thanks for your answer,

unfortunately concat is not good, if you have million of rows

Re: How to check if a value exist in a listbox

sunny_talwar — Wed, 27 May 2015 14:08:03 GMT

I think you are right. Clever Anjos‌'s solution seems to be much more efficient.

Best,

Sunny