topic Re: Pivot layout problem in QV NOV2017 in QlikView

Pivot layout problem in QV NOV2017

karolina_ — Thu, 05 Jul 2018 10:36:05 GMT

We have upgrade from 11.20 to NOV2017 and there is problem with pivot layout.
All expression by default are in rows instead of columns. It is not possible to move alone expression to the top to make them go to columns. The best layout I was able to make was to move expressions with one dim (the one closest to expressions) to the top and select one value to that dim.
Bookmark made in QV 11.20 to clear pivot layout is not working good in QV NOV2017. It moves expression to rows not to columns.

Re: Pivot layout problem in QV NOV2017

niclaz79 — Thu, 05 Jul 2018 10:46:13 GMT

Hi,

You should be able to drag the column of the expressions to be above the top line. It will indicate once moved.

Also, check your pivot table preferences to not have anything locked.

Re: Pivot layout problem in QV NOV2017

karolina_ — Thu, 05 Jul 2018 11:58:45 GMT

Hi Niclase

I know I should be able to do this, but i am not. Every time I drag expression to the top also dimesssions are moved there.