topic Show/Hide from the click of a textbox in QlikView

Show/Hide from the click of a textbox

Tue, 10 Feb 2015 12:35:54 GMT

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

Re: Show/Hide from the click of a textbox

tresB — Tue, 10 Feb 2015 12:42:13 GMT

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

Re: Show/Hide from the click of a textbox

maxgro — Tue, 10 Feb 2015 12:51:00 GMT

PFA

Re: Show/Hide from the click of a textbox

Tue, 10 Feb 2015 12:54:52 GMT

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

Re: Show/Hide from the click of a textbox

Wed, 11 Feb 2015 04:48:54 GMT

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

Re: Show/Hide from the click of a textbox

Wed, 11 Feb 2015 05:00:48 GMT

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