Using dual in calculated pivot dimension I cannot collapse the following dimensions
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?
Re: Using dual in calculated pivot dimension I cannot collapse the following dimensions
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!