Multiple drill down through fields in pivot table

Tue, 16 Aug 2016 13:11:38 GMT

Dear Qlikview Gurus,

We have a requirement where we have to show Sales in below format i.e there is hierarchy in fields. when user clicks vendor it should display business unit which is at multiple level and when business unit is clicked it should display base unit which is at multiple level, sales should be displayed at individual as well as at vendor and business unit by aggregating all levels.

Please help to achieve it ,we are trying in pivot table. Attached document is for reference and let me know if any details needed.

Fyi: all fields i.e vendor , business unit and base are in different tables.

Vendor Sales

Business Unit

Base unit

TCS

Marketing Sales

CRM

US Studio

Tax

PIT Stop

Administrative Services

CRM

US Studio

Tax

PIT Stop

Wipro

Marketing Sales

CRM

US Studio

Tax

PIT Stop

Administrative Services

CRM

US Studio

Tax

PIT Stop

Thanks in advance.

Regards,

Kishore.

Re: Multiple drill down through fields in pivot table

jonathandienst — Tue, 16 Aug 2016 13:18:01 GMT

Create a drill group in the front end (Edit Groups from the Dimensions tab, or Groups from the Document Properties). The group should contain the fields Vendor, Business Unit, Base Unit. Then use the drill group as a dimension in the chart or table.

Re: Multiple drill down through fields in pivot table

Thu, 18 Aug 2016 13:20:54 GMT

Thank you

topic Re: Multiple drill down through fields in pivot table in QlikView

Multiple drill down through fields in pivot table

Re: Multiple drill down through fields in pivot table

Re: Multiple drill down through fields in pivot table