topic Re: Using dual in calculated pivot dimension I cannot collapse the following dimensions in QlikView

Using dual in calculated pivot dimension I cannot collapse the following dimensions

desertmatt — Sat, 16 Nov 2024 19:22:44 GMT

Dear All,

Am using the dual formula in 2 calculated pivot dimensions (cannot get these column to sort properly otherwise - even with proper expression). With this sorting works fine but the labels of the other dimensions cannot be collapsed (keeps the columns for these dimensions always visible )

Am using v. 12.40.20100.0 - is there a solution for this or is this a bug?

Thank you so much for your feedback and help.

regards

Matt

Re: Using dual in calculated pivot dimension I cannot collapse the following dimensions

rubenmarin — Sun, 29 Dec 2019 18:03:54 GMT

Hi Matt, al least in 12.30 I have two calculated dimensions that can expand/contract. Can you upload a sample that doesnt works in your version to check in this one?

Well, I attach one to do the opposite..

Re: Using dual in calculated pivot dimension I cannot collapse the following dimensions

desertmatt — Mon, 30 Dec 2019 03:57:30 GMT

Dear Rubin

Thank you for your answer.

Can you please add one more non-calculated dimension and let me know whether this collapses too?

My first 2 calculated dimensions collapse without problem too but the following non-calculated dimension columns don't collapse just the content is cleared -but full column width and labels are preserved (please see below) 😞

I feel the Qlikview Pivot is real buggy - first the dimension sorting by expression creates erratic results - and now I found the dual sorting solution this keeps the columns open 😞

Digging further around I found this Support entry which says this is now by design and gives a VERY useless "workaround" (sorry - but the point of pivots is to maintain a hierarchical order - so no point rearranging the columns...really...) https://support.qlik.com/articles/000062439

So I'm urgently looking for some real solution - anything in JSON scripting maybe (collapse dimensions) - but really don't know anything about these scripting methods and where to begin?

I cannot understand how the otherwise highly respected Qliview team could not look into pivots more and make sorting and collapsing 100% working as needed - pivots are such important daily tools - please!

Kind regards

Matt

Re: Using dual in calculated pivot dimension I cannot collapse the following dimensions

rubenmarin — Mon, 30 Dec 2019 20:11:54 GMT

Hi Matt, I added another non calculated dimension and contract/expand still seems to work, maybe has something to do with the expression and/or the sort expression and/or data model.

Can you make a dumb sample with inline data to test? if it still happens in tahat sample please upload it to take a look.

Regards.

Re: Using dual in calculated pivot dimension I cannot collapse the following dimensions

desertmatt — Sat, 04 Jan 2020 08:43:09 GMT

Thank you Ruben,

I solved this one by putting the expression (Dual...) in the load script.

As per this https://support.qlik.com/articles/000062439 it seems to be by design and we have to deal with this - till the Qlikview team shows mercy and corrects this 😉

Thank you very much for your time looking into this.

regards

Matt