topic Need Help In Hierarchy in QlikView

Need Help In Hierarchy

Tue, 30 Aug 2011 14:34:10 GMT

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

Need Help In Hierarchy

SunilChauhan — Tue, 30 Aug 2011 14:41:53 GMT

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

Need Help In Hierarchy

Tue, 30 Aug 2011 15:04:22 GMT

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.............

Need Help In Hierarchy

SunilChauhan — Tue, 30 Aug 2011 15:17:21 GMT

sorry

go to sheets one by one

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

filedName='Hardware' in hardware sheet

filedName='Desktop' in 'Desktop'sheet

Need Help In Hierarchy

Wed, 31 Aug 2011 07:30:46 GMT

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

Re: Need Help In Hierarchy

its_anandrjs — Wed, 31 Aug 2011 07:46:17 GMT

Hi,

You need to put the same code

=YourField = 'Types'

Like for ever sheet that you have

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

Need Help In Hierarchy

Wed, 31 Aug 2011 09:27:10 GMT

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