topic Re: QlikView 12.4 SR1 Pivot Table issue in QlikView

QlikView 12.4 SR1 Pivot Table issue

m_woolf — Fri, 20 Sep 2019 15:36:42 GMT

We have just upgraded from QV 12.1 SR8 to QV 12.4 SR1 in our test environment.

We are seeing what looks like a bug in pivot tables.

If any dimension in the pivot table contains a function or even a comment after the field, when the pivot table is collapsed the dimension headers are still visible.

The forum won't allow me to post an image.

If we remove the function or comment so the dimension is just a field name, then the dimension headers collapse as expected.

Has anyone else noticed this issue?

Do you have a solution other than changing all pivot tables to remove function and comments from dimensions?

Re: QlikView 12.4 SR1 Pivot Table issue

dplr-rn — Fri, 20 Sep 2019 16:30:13 GMT

can you give an example of the function you use as calculated dimension

Re: QlikView 12.4 SR1 Pivot Table issue

m_woolf — Fri, 20 Sep 2019 16:43:32 GMT

Any function will do. I tried upper(Field), Date(Field,'MM/DD/YYYY'), if(Field='Value'.Field). Even Field //Comment.

Re: QlikView 12.4 SR1 Pivot Table issue

m_woolf — Fri, 20 Sep 2019 16:48:18 GMT

I attached a qvw to show the issue.

Re: QlikView 12.4 SR1 Pivot Table issue

m_woolf — Fri, 20 Sep 2019 16:53:39 GMT

This qvw better shows the issue. All the dimension sare expanded. Then the first dimension is collapsed.

Re: QlikView 12.4 SR1 Pivot Table issue

dplr-rn — Fri, 20 Sep 2019 16:54:55 GMT

That is odd. i agree i am able to replicate the behavior from scratch (not on your qvw)

Did you raise ticket with qlik?

Unfortunatly i can think of anything other than moving the calculation to the script. Sorry

Re: QlikView 12.4 SR1 Pivot Table issue

m_woolf — Fri, 20 Sep 2019 18:15:38 GMT

I opened a ticket with Qlik. Their rsponse:

"This was reported to R&D via bugs QV-16336 and QLIK-84622. The bug regarding the collapse behavior was closed as working as designed."