listbox connections

[Anonymous]

is there a way to make a listbox effect only one table, but not the other tables?

thanks.

[sunny_talwar]

Create an alternate state and then push this list box to the alternate state and refer the alternate state in set analysis of your one table.

HTH

Best,

Sunny

[Anonymous]

how do we use the alternate state in the set analysis of table?

[sunny_talwar]

You meant a literal table box object? If it is a table box object than you will need to push the whole table to the alternate state. Else you can mimic a table box using a straight table and use alternate state in set analysis of the expression

[Anonymous]

could you tell me where do ı put the alternate state here?

=If(not(IsNull(ID))and not(IsNull(ACTV)) ,'YES','NO')

this is the expression that ı use in my table.

[sunny_talwar · Accepted solution]

Try this:

=If(not(IsNull(Only({NameOfAlternateState} ID)))and not(IsNull(Only({NameOfAlternateState} ACTV))) ,'YES','NO')

[sunny_talwar]

Although I am not sure if Qlik Sense has Alternate State. If it doesn't have alternate state than you will have to go a longer route of adding {<ListBox = >} to all your other objects where you don't want ListBox selections to impact anything in that table.

Hope this make sense.

Best,

Sunny

[Anonymous]

ı have made it "new to qliksense" by mistake, it is under new to qlikview.

ı corrected it.

[sunny_talwar]

‌Oh okay... Then you should be able to use the above expression with alternate state in set analysis. See if that worked?

Best,

Sunny

[Anonymous]

sunindia thank you so much.

it worked.