Pivot Export - Drill-Down Issue

[parthakk]

Hi Everyone,

I have a pivot table with 6 dimension. And i would like to export this data into excel when we drill-down to second level. But problem here is i need to go and click on every plus icon to attain complete drill at second level. Attaching a sample image which has 3 dimension.

Can any one suggest an extension for this or any way to achieve this?

Thanks,

Partha K

[dsharmaqv]

You can take your cursor over the field that you want to expand ....right click and and select expand all.

Or

Go to properties--> Presentation and check the box always fully expanded

[parthakk]

Hi Deepak,

Thanks for your reply.

However,I am using qlik sense and not qlik view.

Also i cannot go for fully expanded option because i have 6 dimension but want to expanded for second level drill.

Thanks,

Partha K

[#4]

Hi Partha,

Sad story is, there's no native function of column expansion in qliksense, unlike in qlikview. 🙂  I've got the same issue.

Ryan

[parthakk]

Hi Ryan,

If not native function then have you come across any other extension or any workaround available? Because business users are facing this issue and we need to get back them at earliest.

Thanks

Partha K