topic Re: Move column in pivot table in QlikView

Move column in pivot table

Wed, 23 Jul 2014 09:57:30 GMT

Hello everyone,

On the image attached I have several columns that are dimensions. The last column (the one on the right) comes from a expression.

I would like to know how I can change the expression column to the left, to be the first column.

Thank you in advance!

Re: Move column in pivot table

Wed, 23 Jul 2014 10:31:14 GMT

Hi Ivo,

As far as I am concerned for Pivot and Straight tables, you cannot place the expressions at the start(first column) when you have dimensions in the table.

Thanks

Sabal

Re: Move column in pivot table

ashfaq_haseeb — Wed, 23 Jul 2014 10:36:51 GMT

Hi,

Go to expression tab and play with promote and demote feature.

Regards

ASHFAQ

Re: Move column in pivot table

aveeeeeee7en — Wed, 23 Jul 2014 10:48:58 GMT

You can just do Drag & Drop. Place your Mouse Cursor on Expression Label Header and Hold it and Move the Cursor while holding it and place it where you want.

But Kindly check after placing, it does not affect your Result.

Regards

Aviral Nag

Re: Move column in pivot table

Wed, 23 Jul 2014 11:02:28 GMT

Hello guys, thank you for the replies.

@Ashfaq Mohammed: I only have one expression and cannot promote/demote expressions and dimensions.

@Nag Aviral: I drag it to to position I want but when I drop, the column stays on the same place and the title of the column disapears...

@Sabal Saxena: you are probably right!!

Best regards

Re: Move column in pivot table

ashfaq_haseeb — Wed, 23 Jul 2014 11:05:28 GMT

Hi,

You can rearrange.

Can you share a sample.

Regards

ASHFAQ

Re: Re: Move column in pivot table

Wed, 23 Jul 2014 12:08:38 GMT

Sending the sample

Re: Move column in pivot table

sorrakis01 — Wed, 23 Jul 2014 12:13:06 GMT

hi Ivo,

Where's the problem? what do you want to do, exactly?

Re: Re: Re: Move column in pivot table

ashfaq_haseeb — Wed, 23 Jul 2014 12:13:07 GMT

Hi,

Have a look at the attached images.

You just need to drag columns, by selecting column header for dimensions only.

You cannot drag expression column to be as a first one.

Regards

ASHFAQ

Re: Move column in pivot table

sorrakis01 — Wed, 23 Jul 2014 12:20:05 GMT

Hi Ivo,

You can't put the expresion in the first position,

Regards.

Re: Move column in pivot table

Wed, 23 Jul 2014 12:26:55 GMT

You can do this on a straight table, not a pivot table.

*** Note QlikView standard is to not use pivot tables as pivot tables slowes the model down by alot.

Regards,
Marius

Re: Move column in pivot table

sorrakis01 — Wed, 23 Jul 2014 12:31:38 GMT

Correct.

Re: Re: Move column in pivot table

Wed, 23 Jul 2014 12:57:07 GMT

What I needed was precisely to put the expression column in the first position.

Since this cannot be done with pivot tables, I have to find another way.

I will explore another options.

Thank you for everyone's reply!

Best Regards

P.S. If I find a solution I will post it to try to help another users.

Re: Re: Move column in pivot table

sorrakis01 — Wed, 23 Jul 2014 13:03:21 GMT

Perfect,

but you can do it with a straight table?

Good Luck,

Re: Move column in pivot table

Wed, 23 Jul 2014 13:14:48 GMT

Hi Marques

I too have similar issue, I am trying to display a column under dimensions(calculated dimension) after the expression column.But it allows to drag the dimension columns in report but the Expression column header will be grayed

out dark,and it doesn't allow to change it from Last position.

Please post if you find any luck moving expression ,that might help me as well

Rajesh

Re: Move column in pivot table

Wed, 23 Jul 2014 13:18:07 GMT

Hi Rajesh,

That is what pivot tables in QlikView does if you try to move them infront of the dimensions.

You can not do this in a pivot table, however as stated above you can do it with a straight table in QlikView.

Regards,
Marius

Re: Move column in pivot table

Anonymous — Wed, 23 Jul 2014 13:21:34 GMT

Its possible in Straight table not in pivot table.

Re: Move column in pivot table

Wed, 23 Jul 2014 13:30:07 GMT

Hi Marius,

Thanks you for replying, but in my table i have a measure object which should be shown across product.

for each customer.So for a single customer there can be multiple products so Straight table will show the

results as repeating customer# for diff product.But user wants to see the data in single line where Measure

is pivoted across product and also a dimension column to the end of Pivot table

Thanks

Rajesh

Re: Move column in pivot table

Wed, 23 Jul 2014 13:33:13 GMT

Adding column to the end of Pivot Table

Here is the link to actual problem posted.Please have a look.

Re: Move column in pivot table

Anonymous — Wed, 23 Jul 2014 13:35:02 GMT

It says i am unauthorized to see the post can you please send me a valid link.