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

how to create drill through using filed level in bar chart

Anonymous — Wed, 03 Feb 2016 17:43:16 GMT

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:

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

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

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

Gysbert_Wassenaar — Wed, 03 Feb 2016 18:40:55 GMT

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.

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

Anonymous — Thu, 04 Feb 2016 15:24:37 GMT

hi gwassenaar

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

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

Anonymous — Mon, 29 Feb 2016 18:54:46 GMT

Usng Ad hoc reports we may do that

please refer below link

Adhoc reporting in Qlikview