Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bobby_chowdary
New Contributor III

how to create drill through using filed level in bar chart

hi team,

Good Day

i am facing a issue on bar chart.since i am not able to say it may be possible or not

i created bar chart in that i want to drill through to filed level values

exapmle:

418605.image5.jpg

after creating above bar chart .when i click product d ..when i click on PRODUCR D i want to display all PRODUCT D  types as well values in same chart.

BELLOW OUTPUT I WANT TO SEE AFTER CLICKING PRODUCT

418605.image5.jpg

after that when i click ant product types i want main chart to display like first chart

Please suggest me if it possible using macros or creating variables or some other process

Regards,

Bobby

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: how to create drill through using filed level in bar chart

Create a DrillDown Group with the two fields you want to display on the Dimensions tab of the charts properties window and use this new group as chart dimension.


talk is cheap, supply exceeds demand
Highlighted
bobby_chowdary
New Contributor III

Re: how to create drill through using filed level in bar chart

hi

Thanks for giving the reply

can you give one example for that and i need dynamically  like i may no need  to create drill down on particular two fields

let us suppose if i click in PRODUCT A i need all the values belong to "product a"

like PRODUCT B and PRODUCT C

if i click any product and i need to display it"s related values

Thanks,

Bobby

Highlighted
bobby_chowdary
New Contributor III

Re: how to create drill through using filed level in bar chart

Usng Ad hoc reports we may do that

please refer below link

Adhoc reporting in Qlikview