Collapse dimension on pivot table

[#1]

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

[#2]

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

[#3]

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

Thanks to everybody. Fiber

[boorgura]

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.

[#5]

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

[#6 · Accepted solution]

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

[#7]

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