idea Re: Pivot table with dynamic Dimension: Collapse does not work as expected. in Suggest an Idea

Pivot table with dynamic Dimension: Collapse does not work as expected.

RashmiRH — Wed, 16 Dec 2020 11:51:44 GMT

The behavior of 'Collapse All' has changed in regards to QlikView 12.50SR2.It was working as expected in QlikView 12.20SR10.

We would like the functionality back as it worked 12.20SR10 also in the latest release.

The problem occurs only with calculated dimensions. But we cannot avoid dynamic dimensions in every scenario, hence this is much needed feature.

Refer to attached Gif

- In QlikView 12.20SR10 the Pivot table now only shows the first two columns of the pivot table. The third Column is hidden. --> this is the expected behavior

- In QlikView 12.50SR2 the third Column is still shown. The header is still visible. The data rows just become empty.

Thnx!

Re: Pivot table with dynamic Dimension: Collapse does not work as expected.

Anonymous — Wed, 16 Dec 2020 12:01:08 GMT

100 % agree!

Sometimes you need a dynamic dimension. One typical example is the class() function. For example the dynamic dimension

=class( aggr(sum(Access*Faktor),Year,UserID),1000000)

We can not preprocess this in the script, because the result needs to be calculated based on the current enduser selection.

--> therefore we need the "COLLAPSE ALL" to work with dynamic dimensions.

Re: Pivot table with dynamic Dimension: Collapse does not work as expected.

mbrade — Fri, 18 Dec 2020 13:48:39 GMT

Same in 12.40 - wanted to put in also...

needs def. to be fixed!

thx!

Re: Pivot table with dynamic Dimension: Collapse does not work as expected. - Status changed to: Open - Collecting Feedback

Yuliya_Kiperberg — Wed, 21 Jul 2021 02:57:23 GMT

Thank you very much for your feedback, we really appreciate it!

We're currently investigating this request and will provide an update once we have a decision.

Re: Pivot table with dynamic Dimension: Collapse does not work as expected.

rva_be-terna — Mon, 08 Nov 2021 08:10:31 GMT

hi!

Looks like this is fixed in QlikView 12.60 SR1.

Thx,

Roland

Re: Pivot table with dynamic Dimension: Collapse does not work as expected. - Status changed to: Delivered

Yuliya_Kiperberg — Fri, 19 Nov 2021 14:20:15 GMT