topic Collapse dimension on pivot table in QlikView

Collapse dimension on pivot table

Tue, 09 Nov 2010 12:08:17 GMT

Hi to all!

I use a few dimensions on a pivot table report but the only I couldn´t collapse is a calculate dimension . The expression is PROJECT&' - '&DESCRIPTION. Any suggestion?

Thanks, Fiber

Collapse dimension on pivot table

Tue, 09 Nov 2010 13:23:39 GMT

My question is: Have I mark any option to collapse a calculated dimension in other tab? Or simply, when the dimension is calculated qlikview couldn´t collapse it.

Thank you for your response.

Fiber

Collapse dimension on pivot table

Tue, 09 Nov 2010 18:00:48 GMT

This morning I posted a question. Has anyone any idea about collapse and expand a calculated dimension?

Thanks to everybody. Fiber

Collapse dimension on pivot table

boorgura — Tue, 09 Nov 2010 18:09:52 GMT

Please check if the "Always Fully Expanded" option is checked in the Presentation tab of properties.

It has to be unchecked.

Let me know if it works.

Collapse dimension on pivot table

Tue, 09 Nov 2010 18:32:43 GMT

I checked this option before write this post. It´s unchecked, but plus simbol on the right hand no appears. Sorry but I can´t paste an image.

Fiber

Collapse dimension on pivot table

Tue, 09 Nov 2010 18:50:04 GMT

I had this issue related to V9 SR4 ( I'm not sure if it was SR4 or 3)

This happened with calculated dimensions, they always appeared expanded without a way to collapse it.

I advise you to test by installing last Qlikview V9 version then open the document. If it works, you'll have to migrate your server in the same SR ...

Or do not use calculated dimension by replacing them by dimensions calculated in the script.

I hope this help you !

Regards,

Sébastien

Collapse dimension on pivot table

Tue, 09 Nov 2010 18:57:14 GMT

Thank you for your response. I´m sure it will more quickly to calculate dimension in the script. It was easier than I thought.

Fiber