Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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."
Any function will do. I tried upper(Field), Date(Field,'MM/DD/YYYY'), if(Field='Value'.Field). Even Field //Comment.
I attached a qvw to show the issue.
This qvw better shows the issue. All the dimension sare expanded. Then the first dimension is collapsed.
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
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."