topic Re: Pivot table field moving to horizontal position in QlikView

Pivot table field moving to horizontal position

Fri, 22 May 2015 06:31:34 GMT

Hi,

In my application I am not able to drag some fields to horizontal position of Pivot table. Please suggest.

Regards,

Navdeep

Re: Pivot table field moving to horizontal position

danieloberbilli — Fri, 22 May 2015 06:40:18 GMT

sorry - I was wrong before

please check here:

Re: Pivot table field moving to horizontal position

Fri, 22 May 2015 06:41:32 GMT

Hi,

Yes it's checked for those fields.

Re: Pivot table field moving to horizontal position

danieloberbilli — Fri, 22 May 2015 06:47:15 GMT

You drag&drop them by grapping the header of the column/dimension. If this does not work, then maybe you confuse the column/row with one of the expressions. That could easily happened if e.g. you have Field1 as dimension but also as expression

Re: Pivot table field moving to horizontal position

PrashantSangle — Fri, 22 May 2015 06:48:04 GMT

Hi,

Can you post example???

Regards

Re: Pivot table field moving to horizontal position

prajapatiamar38 — Fri, 22 May 2015 06:50:39 GMT

Hi,

Select the header of the field which u want to drag to the horizontal position then drag it to the right.And drop where you want to drop.

I hope it will work.

Re: Pivot table field moving to horizontal position

jyothish8807 — Fri, 22 May 2015 06:50:57 GMT

Hi Navdeep,

Are you using dimensions? You can drag only dimensions to the horizontal position.Expressions you cant i beleive.

Can you post a sample App?

Regards

Re: Pivot table field moving to horizontal position

Fri, 22 May 2015 06:55:22 GMT

Hi,

Yes, I am trying to drag dimension and it was working fine till last reload, now suddenly all dimensions are not responding to pivoting.

sorry guys, I can't post the app as it's huge one, if any of you have faced same issue in past or have any idea please suggest.

Regards,

Navdeep

Re: Pivot table field moving to horizontal position

PrashantSangle — Fri, 22 May 2015 07:01:17 GMT

Hi,

reduce data with then post

for that debug ->Limited Load -> enter 1000 records

Regards

Re: Pivot table field moving to horizontal position

Shisho_Karsenty — Mon, 07 May 2018 10:41:33 GMT

Same problem...

Anyone?

Re: Pivot table field moving to horizontal position

Shisho_Karsenty — Mon, 07 May 2018 10:50:37 GMT

OK,
I switch from straight table to pivot table and it's work for me(:
Properties --> General --> Chart Type --> Pivot table

Re: Pivot table field moving to horizontal position

ValeriyaBartosh — Thu, 09 Aug 2018 07:38:49 GMT

Hello,
Pivoting often does not work correctly, if you have such situation (see pic)

Re: Pivot table field moving to horizontal position

lfholland — Thu, 09 Aug 2018 19:48:25 GMT

I had this same problem and it was exactly what Valeria posted. Once I got rid of the invalid dimension, it started working again.

Re: Pivot table field moving to horizontal position

Margaret — Fri, 31 Jul 2020 15:27:28 GMT

I have this problem often and none of the proposed solutions work. Sometimes it just eventually starts working. This time it hasn't yet. Would love a reliable solution...