topic If no selection - Alternate State in QlikView

If no selection - Alternate State

Wed, 25 Nov 2020 16:16:04 GMT

So if there is no Selection in a Multibox with below dimension and alternate state I want a text object not to be displayed.

What is wrong with the condition?

=If(=GetSelectedCount(Concat({[GroupZ]}_Metric))=0, false(), true())

Re: If no selection - Alternate State

sunny_talwar — Thu, 14 Apr 2016 13:44:24 GMT

May be try this (not sure what condition you want):

=Len(Trim(Concat({[GroupZ]} _Metric))) > 0

=Len(Trim(Concat({[GroupZ]} _Metric))) = 0

Re: If no selection - Alternate State

avinashelite — Thu, 14 Apr 2016 13:47:45 GMT

try like this

If(GetSelectedCount(Concat({[GroupZ]}_Metric))=0, 0, 1)

paste this expression in the text box properties > Layout > show > conditional

based on the data text box will appear and disappear

Hope this helps you

Re: If no selection - Alternate State

Thu, 14 Apr 2016 14:04:50 GMT

Well, works out but when plugging it in in the above if condition the text object is not shown when making a selection?!

Re: If no selection - Alternate State

sunny_talwar — Thu, 14 Apr 2016 14:26:19 GMT

You are using this in the show/hide condition right? If what I just asked is true, then you don't need the if statement. Just use it as is without the if statement

Re: If no selection - Alternate State

Thu, 14 Apr 2016 14:36:07 GMT

Yes I do: properties > Layout > show > conditional

Still, if I do make a selection in the multibox the text will not show up again.

Re: If no selection - Alternate State

sunny_talwar — Thu, 14 Apr 2016 14:59:10 GMT

Can you try this:

=Len(Trim(GetFieldSelections(_Metric, ',', 100, 'GroupZ'))) > 0

Re: If no selection - Alternate State

Mon, 25 Apr 2016 07:14:50 GMT

Another issue has come across with layout and alternate states and I am not sure whether this is a bug?!

In the attached example I only want to show the multibox if the selection in the list box is right.

This works fine until I define different alternate states for each of the multi boxes as the conditional layout does not work anymore.

For Network I have disabled the conditional layout so you can see the issue.

Is there any solution?

Re: If no selection - Alternate State

sunny_talwar — Mon, 25 Apr 2016 15:31:22 GMT

Not sure I understand, but can you check now?