Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

drill down

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)?

Labels (1)
7 Replies
Anonymous
Not applicable
Author

Hi,

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

Regards

Vinod Gadiputi

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi ,

Please find Attachment it will help you.

Thanks,

Arvind Patil

Anonymous
Not applicable
Author

i canno see any attachment

Anonymous
Not applicable
Author

i dont want to create a drill down group

i want a drill down view as described above

rahulpawarb
Specialist III
Specialist III

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

Kushal_Chawda
MVP
MVP

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

Anonymous
Not applicable
Author

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