Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

what condition should i apply in multibox?

Hi all

Ive these two objects; one multibox containing just codes and a straight table which contains the detailed description of the codes in around 7 columns. what i want is a scenario where the straight table is hidden somewhere and the sheet is showing just codes so when i select any one of them i want that hidden straight table to pop up and show the description against that code. so how do i do that?

Ive tried that auto minimization and condition but its not working properly.

Kindly help

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: what condition should i apply in multibox?

Hi,

In Straight Table try like this


Properties>Layout>Select Show Sonditional -> and give


=GetSelectedCount(CodeFieldName) > 0


Note: Replace CodeFieldName with your actual field name.


Hope this helps you.


Regards,

Jagan.

18 Replies
Not applicable

Re: what condition should i apply in multibox?

Hi Rabia, Can u share sample app. Thanks

Re: what condition should i apply in multibox?

Hi Rabia,

Use the Conditional hiding concept.

Create a variable and use that variable to hide on the conditional basics.

Charts>Properties>Layout>Show conditional.

Please find the attachment for the same.

Not applicable

Re: what condition should i apply in multibox?

Im afraid i cant. since it contains some sensitive information.

Not applicable

Re: what condition should i apply in multibox?

I tried but its not working.

MVP
MVP

Re: what condition should i apply in multibox?

Hi,

In Straight Table try like this


Properties>Layout>Select Show Sonditional -> and give


=GetSelectedCount(CodeFieldName) > 0


Note: Replace CodeFieldName with your actual field name.


Hope this helps you.


Regards,

Jagan.

Re: what condition should i apply in multibox?

Hi,

You can use field event trigger and set variables for the same.

Can you post a sample file.

Or

simple go to Chart properties --> Layout --> Select Show conditional --> and write below formulae.


=GetSelectedCount(yourfield) >= 1

Regards

ASHFAQ

Re: Re: what condition should i apply in multibox?

Please see the attachment for the solution.

Highlighted
Not applicable

Re: Re: what condition should i apply in multibox?

Thank you so very muchhhhhh it worked

Not applicable

Re: Re: what condition should i apply in multibox?

Jagan

Can u tell me if i want to do the same but with LED chart. as in if i hover my mouse over LED chart and in action if ive selected activate straight table so when i click the LED chart it will pop up the straight table.