topic Re: drill down in QlikView

drill down

Anonymous — Wed, 26 Jul 2017 10:34:29 GMT

am using a graph which has grouped dimensions 0-3,4-6 etc shown in form of bars

as a dimension am using a cyclic group created

now what i want when i click on 0-3 it should give me all the values as from 0 1 2 3

how is it possible?

can i use getselectedcount(groupname)?

Re: drill down

Anonymous — Wed, 26 Jul 2017 10:37:14 GMT

Hi,

Can you share the sample file, it will be helpful to understand the requirement.

Regards

Vinod Gadiputi

Re: drill down

arvind_patil — Wed, 26 Jul 2017 10:46:24 GMT

Hi ,

Please find Attachment it will help you.

Thanks,

Arvind Patil

Re: drill down

Anonymous — Wed, 26 Jul 2017 10:59:33 GMT

i canno see any attachment

Re: drill down

Anonymous — Wed, 26 Jul 2017 11:01:57 GMT

i dont want to create a drill down group

i want a drill down view as described above

Re: drill down

rahulpawarb — Wed, 26 Jul 2017 11:04:16 GMT

Hello DG,

As a workaround, I have created below sample script which will load ProductId and its respective sales figures. Also created a bucket for ProductIds.

Sales:
LOAD ProductId, Sales, If(ProductId <=3, '0-3', '4-6') AS ProductBucket;
LOAD * INLINE [
ProductId, Sales
0, 1000
1, 2000
2, 4000
3, 8000
4, 16000
5, 32000
6, 64000
];

Post this created a Drill Down Group on Dimension tab (Products: ProductBucket -> ProductId) and used it as dimension in bar chart.

Hope this will serve the requirement.

Refer the attached sample application.

Regards!

Rahul Pawar

Re: drill down

Kushal_Chawda — Wed, 26 Jul 2017 11:22:14 GMT

Add that field in Drill down group which you want show as dimension when clicking on bucket

Re: drill down

Anonymous — Wed, 26 Jul 2017 12:07:36 GMT

am using a cyclic group

and a combo chart

how is this possible in that case

and in that group i have 5 fields

and in each field i have values in range0-9