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