Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thank you