topic Re: conditional show multiple disappears in QlikView

conditional show multiple disappears

Anonymous — Thu, 09 Nov 2017 15:54:29 GMT

hi there,

ı have a problem,

ı am using "conditional show" based on listbox selections.

it is fine.

ı have listbox like that etc:

and

conditional_object_a

conditional_object_b

conditional_object_c

when I select the listbox one by one there is no problem.

aa >> conditional_object_a

bb >> conditional_object_b

cc >> conditional_object_c

But when I select 2 conditions for ex:

aa and bb >> nothing!

but it should show both conditional_object_a and conditional_object_b

how can I fix this?

thnks for helps!

Re: conditional show multiple disappears

antoniotiman — Thu, 09 Nov 2017 16:02:11 GMT

May be like this

=SubStringCount(Concat(Field),'aa')

=SubStringCount(Concat(Field),'bb')

=SubStringCount(Concat(Field),'cc')

Re: conditional show multiple disappears

Anonymous — Thu, 09 Nov 2017 16:45:27 GMT

no way, it still disappears when I select more than one listbox selections

Re: conditional show multiple disappears

Peter_Cammaert — Thu, 09 Nov 2017 16:49:27 GMT

What does a textbox with expression =Concat(Field, ', ') show when you select 'aa' and 'bb' in your listbox?

Re: conditional show multiple disappears

Anonymous — Thu, 09 Nov 2017 16:54:13 GMT

when I select both ( at same time) it shows nothing.

Re: conditional show multiple disappears

Peter_Cammaert — Thu, 09 Nov 2017 17:02:09 GMT

Int the TextBox expression, did you replace the placeholder "Field" with the actual name of the field you are showing in the listbox?

Re: conditional show multiple disappears

Anonymous — Thu, 09 Nov 2017 17:03:45 GMT

sure

Re: conditional show multiple disappears

Peter_Cammaert — Thu, 09 Nov 2017 17:06:03 GMT

Weird. Please post an example document or we may end up asking/answering a multitude of boring questions.

You're not using Alternate States, are you?

Re: conditional show multiple disappears

Anonymous — Thu, 09 Nov 2017 17:11:20 GMT

my file is so big.

I am writing it to the lay out > show conditional

the thing I want to do is,

I have 3 selections and 3 texbox objects. each textbox object is shown conditional based on listbox selections.

when I select the listbox one by one, they appear one by one, but when I make 2 selections in listbox they do not appear.

the problem is that.

thanks again for your effort.

Re: conditional show multiple disappears

Peter_Cammaert — Thu, 09 Nov 2017 17:16:57 GMT

Then please create a new document, copy the relevant stuff on the Main sheet, add some dummy data in your load script, make sure that you are experiencing the same anomaly, and post the document here.

The information you are providing isn't enough to explain what goes wrong. Or we would have done so from the beginning.

Re: conditional show multiple disappears

Anonymous — Fri, 10 Nov 2017 06:25:39 GMT

you are right I will.

Re: conditional show multiple disappears

srivastalans — Fri, 10 Nov 2017 07:52:05 GMT

PFA.

Re: conditional show multiple disappears

Anonymous — Mon, 13 Nov 2017 07:51:49 GMT

yes. that was what I meant. thanks Srivastalan!