topic Re: Creating pivot subgroups in QlikView

Creating pivot subgroups

Sun, 29 Mar 2015 11:00:52 GMT

hi..

I have a request to create pivot table with subgroups,

Ex : when we click on SEC memeber, we need to show region wise data (APAC, NA, EMEA etc..,) and when we click on region wise we should get data by countrywise.

Pls find the attachment for more info.

Re: Creating pivot subgroups

hic — Mon, 30 Mar 2015 08:32:12 GMT

If you

create a drill-down group (Settings > Document properties > Groups) using "SEC Member", "Region" and "Country"
Use this drill-down group as dimension

you will get exactly this.

HIC

Re: Creating pivot subgroups

Mon, 30 Mar 2015 13:11:29 GMT

Thanks a lot Henric its so useful.

Re: Creating pivot subgroups

Tue, 31 Mar 2015 11:33:01 GMT

I have one more question like...in pivot table in expression Dec is in one row and under this row permanent,temporary and total own in another row.

Please find the attached screen shot..

please help me.