topic Pivot Table - Keep Column Position in QlikView

Pivot Table - Keep Column Position

pkelly — Tue, 22 Apr 2014 14:52:02 GMT

Hi All,

Been working on a dynamic Pivot Table where the user can select the dimensions / values that they are looking to see from a list box...

Got some great ideas from an example QlikView app that was previously posted - have included this with this discussion...

Have hit an issue which I am trying to resolve...

Screenshot 1.jpg shows the layout that I want to keep - note DateDelivery is going along the top row / 2 expressions being displayed...

Screenshot 2.jpg shows the layout after I have deselected one of the expressions i.e. am only showing 1 expression - note DateDelivery is now displaying as a normal column.

If I select another expression to display, DateDelivery moves back to the top row...

Is there anything that I can do that can force DateDelivery back to the top row regardless of how many Dimensions / Expressions have been selected?

Thanks

Paul

Re: Pivot Table - Keep Column Position

hopkinsc — Tue, 22 Apr 2014 15:12:21 GMT

can you post an example of the issue you are experiencing?

Re: Pivot Table - Keep Column Position

Tue, 22 Apr 2014 15:20:59 GMT

Are you using calculated dimension like the sample? I think that's where the issue is. If you are, then just use DateDelivery as your second dimension, and Drag that column up your Pivot for a horizontal presentation..

Re: Pivot Table - Keep Column Position

pkelly — Tue, 22 Apr 2014 15:24:34 GMT

Hi... Example is attached (Forum Example.qvw)...

If you click on the Measures list and select two measures you will see DateDelivery along the top but when you deselect one of the measures it moves to the column...

Re: Pivot Table - Keep Column Position

pkelly — Tue, 22 Apr 2014 15:33:47 GMT

Hi Patrick

Tried this in my live example...

Have three measures (Sales, GP and GM%) in this and have all three selected in the list box.

Added the Dates as dimension and moved to the horizontal row.

Deselected GP and GM% and the Date moves from horizontal to vertical.

Regards

Paul

Re: Pivot Table - Keep Column Position

Tue, 22 Apr 2014 15:50:31 GMT

Hi Paul,

If your unable to attach a sample, kindly list your dimensions and expressions so we can better understand.. thanks!

Re: Pivot Table - Keep Column Position

pkelly — Tue, 22 Apr 2014 16:00:36 GMT

I actually have two versions of this app - I started with non calculated dimensions and used the "Enable Conditional" option e.g. =varViewDivision = 'Yes'

varViewDivision is a variable and I toggle the value of this via a button between yes and No.

Have done the same with the expression on this version.

I still have the same issue - as soon as I get down to one expression being displayed, my date column moves from horizontal to vertical.

If I move the date back to horizontal and selected a second expression to display, the expressions then move to horizontal.

Is there any way that I control where these are displayed via code?

Re: Re: Pivot Table - Keep Column Position

Tue, 22 Apr 2014 17:09:59 GMT

Hi Paul,

I am not getting the same results as you are. (See attached)

What version are you using? Im on 11.2

Re: Re: Re: Pivot Table - Keep Column Position

pkelly — Thu, 24 Apr 2014 17:54:06 GMT

Thanks Patrick

I have created a version with dummy data (albeit very little)...

If you click on the "Gross Profit" Button (the text should turn to white), you will be left with only Sales as a visible expression - note that month moves from horizontal to vertical.

Am on same version as you...

Regards

Paul

Re: Pivot Table - Keep Column Position

Anonymous — Fri, 12 Sep 2014 17:42:02 GMT

I'm having the same issue. Did you ever get a resolution?

Re: Pivot Table - Keep Column Position

pkelly — Fri, 12 Sep 2014 19:54:09 GMT

Unfortunately no Brian...

Re: Pivot Table - Keep Column Position

Tue, 23 Sep 2014 15:00:28 GMT

I too am trying to achieve this where I I have two lists for the user to select from, Would be very keen to hear of a solution for this problem.

Many thanks,

Tom