Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

helen_pip
Contributor II

A list within a drill down group

Hello

Is it possible to have a drill down list in a table, and as soon as you go past a certain level a list of details appear

I.e.

In Group is;

Type

Diagnostic

Then when you click on a Diagnostic you will have a list of people and their demographic information and no ability to drill down any further

Name, Address,  DOB, Post Code,

Can this be achieved?

Thanks

Helen

1 Solution

Accepted Solutions
Not applicable

Re: A list within a drill down group

check this..

7 Replies
Not applicable

Re: A list within a drill down group

try to add expression for each information (Name, Address,  DOB, Post Code,) and set conditional show (chart properties -> presentation -> columns -> conditional show) using getcurrentfield() function

Not applicable

Re: A list within a drill down group

i mean :

=if(getcurrentfield(GroupName)='Diagnostic',1,0)

helen_pip
Contributor II

Re: A list within a drill down group

Hello,

Thank you for your reply

I ahve tried your technique, but cannot get it to work accurately. Could you kidnly take a look at the attached QVW on the original post to see where I may be going wrong 

Kind Regards

Helen

Not applicable

Re: A list within a drill down group

Where is Your file?Smiley Happy

helen_pip
Contributor II

Re: A list within a drill down group

Hello

The file is there now.....Thanks for any help

Helen

Not applicable

Re: A list within a drill down group

check this..

helen_pip
Contributor II

Re: A list within a drill down group

Hello

Thank you very much

Much appreciated

Thanks

Helen