Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show/Hide from the click of a textbox

Hi All,

I'm designing a dashboard and have various audience for the same. Say a set of reports for CIO, Service Manager, Team Leads, etc. Each report has various objects(Containers, list boxes, charts,etc.). I have various text boxes for each category (CIO, Service Manager,etc.).

What I want is to show objects related to CIO report when I click on that text box and hide everything else. Similarly when I click on Service Manager text box it should show objects related to it and hide everything else.

I have a logic something like this:

if(textboxCIO.click, showCIOReport, HideEverythingElse)

if(textboxTeamLead.click, showTeamLeadReport, HideEverythingElse)

However I'm unable to apply this logic in Qlikview. Could you please help me with this?

Awaiting with anticipation.

Best Regards,

Tony

1 Solution

Accepted Solutions
Not applicable
Author

Hi Tony,

1. Create a variable V1 (Alt+ctrl+V > Add> V1)

2. Create a text box/  Button for CIO

Action> Add> External> Set Variable >v1=1

3. Right Click on the objects You want to display for CIO

>Properties> Layout> Show> Conditional v1=1

Do the above step for CIO, Manager, Team Lead.

PFA, It might help You. Click on CIO, Service Manager and Team lead.

The target objects will change.

Warm Regards,

Joshmi

View solution in original post

5 Replies
tresesco
MVP
MVP

In qv you can achieve this using a trigger to set a variable value and using that variable value in object visibility condition.

maxgro
MVP
MVP

PFA

1.jpg

Not applicable
Author

Hi Tony,

1. Create a variable V1 (Alt+ctrl+V > Add> V1)

2. Create a text box/  Button for CIO

Action> Add> External> Set Variable >v1=1

3. Right Click on the objects You want to display for CIO

>Properties> Layout> Show> Conditional v1=1

Do the above step for CIO, Manager, Team Lead.

PFA, It might help You. Click on CIO, Service Manager and Team lead.

The target objects will change.

Warm Regards,

Joshmi

Not applicable
Author

Hi Massimo,

Thanks for the quick response. I'm unable to open the qvw file as I'm using the personal edition, could you please help me with code here?

Thanks & Regards,

Tony

Not applicable
Author

Hi Joshmi,

As you see I'm unable to open the file.

But I got it done thanks to your the detailed explanation.

Best Regards,

Tony