Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Need Help In Hierarchy

    Hi....

                I have Hierarchy like     --Hardware

                                                       Servers

                                                       Storage

                                                       Desktops

                                                       Firewall

             All are the indiviual sheets i want a linking between all the sheets like if we click Servers that sheet should appear,and if we click Storage that sheet should appear....etc,, how can we implement this req,, i have attached sample sheet

1 Solution

Accepted Solutions

Re: Need Help In Hierarchy

Hi,

You need to put the same code

=YourField = 'Types'

Like for ever sheet that you have

like

for

Hardware

          =[ShairA&I]='Hardware'

Desktop

          =[ShairA&I]='Hardware/Desktops'

Firewall

          =[ShairA&I]='Hardware/Firewall'

Servers

          =[ShairA&I]='Hardware/Servers'

Storage

          =[ShairA&I]='Hardware/Storage'

like ways for others sheet, you need to put this codes individually for the shhets in

Sheet properties -> Conditional -> and paste this code for sheets over there.

And let me know if you got it.

Regards

Anand

6 Replies
chauhans85
Esteemed Contributor

Need Help In Hierarchy

use  condition like below for each sheet in layout Condition

filedName='Hardware' in hardware sheet

filedName='Desktop' in 'Desktop'sheet

so on

when you click on hardware it wwill show u hardware sheet and desktop then desktop ssheet and so on

Not applicable

Need Help In Hierarchy

  Hi Sunil,

            Layout Condition means from sheet properties under show sheet-- have to select Conditional option am i right???

                  Am writing like  filedName='Desktop' in 'Desktop'sheet under conditional option from sheet properties  but its not working............

can you elaborate you answer.............

chauhans85
Esteemed Contributor

Need Help In Hierarchy

sorry

go to sheets one by one

sheet properties-> geneeral-> conditional -> type your expression

filedName='Hardware' in hardware sheet

filedName='Desktop' in 'Desktop'sheet

Not applicable

Need Help In Hierarchy

    Sunil still not working with the above exp can you please send me a sample file.......

Re: Need Help In Hierarchy

Hi,

You need to put the same code

=YourField = 'Types'

Like for ever sheet that you have

like

for

Hardware

          =[ShairA&I]='Hardware'

Desktop

          =[ShairA&I]='Hardware/Desktops'

Firewall

          =[ShairA&I]='Hardware/Firewall'

Servers

          =[ShairA&I]='Hardware/Servers'

Storage

          =[ShairA&I]='Hardware/Storage'

like ways for others sheet, you need to put this codes individually for the shhets in

Sheet properties -> Conditional -> and paste this code for sheets over there.

And let me know if you got it.

Regards

Anand

Not applicable

Need Help In Hierarchy

Yes anand its working perfectly..................thanks alot....

Community Browser