topic Re: A list within a drill down group in QlikView

A list within a drill down group

helen_pip — Wed, 06 Mar 2013 14:31:26 GMT

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

Re: A list within a drill down group

Thu, 07 Mar 2013 07:29:35 GMT

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

Re: A list within a drill down group

Thu, 07 Mar 2013 07:30:41 GMT

i mean :

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

Re: A list within a drill down group

helen_pip — Tue, 12 Mar 2013 09:21:21 GMT

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

Re: A list within a drill down group

Tue, 12 Mar 2013 09:25:03 GMT

Where is Your file?:)

Re: A list within a drill down group

helen_pip — Tue, 12 Mar 2013 09:31:06 GMT

Hello

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

Helen

Re: A list within a drill down group

Tue, 12 Mar 2013 09:44:52 GMT

check this..

Re: A list within a drill down group

helen_pip — Tue, 12 Mar 2013 10:04:40 GMT

Hello

Thank you very much

Much appreciated

Thanks

Helen