topic Re: Promoting an expression in between dimensions in QlikView

Promoting an expression in between dimensions

Thu, 10 Sep 2015 11:20:19 GMT

Hi Experts,

I have a Pivot Table where we have some table dimensions and few calculated dimensions and an expression. By default, this expression is getting displayed at the end of the table. I want to promote this expression in between the dimensions so that this gets displayed at the right place.

Please help me.

Thanks in advance.

Regards

Re: Promoting an expression in between dimensions

PrashantSangle — Thu, 10 Sep 2015 11:25:47 GMT

Hi,

Hold and Drag it upto desired location.

Regards

Re: Promoting an expression in between dimensions

gautik92 — Thu, 10 Sep 2015 11:26:54 GMT

place the cursor on the label of the expression hold and drag wherever you want

Re: Promoting an expression in between dimensions

Thu, 10 Sep 2015 11:52:23 GMT

Not happening, not sure if it's because my chart is Pivot Table.

Please help.

Re: Promoting an expression in between dimensions

gautik92 — Thu, 10 Sep 2015 11:57:27 GMT

can you send sample qvw?

Re: Promoting an expression in between dimensions

jonathandienst — Thu, 10 Sep 2015 11:59:58 GMT

I suspect that you can't do that with pivot table because a pivot produces a type of hierarchy in the dimensions.. Is it possible to convert this into a calculated dimension?

Re: Promoting an expression in between dimensions

Thu, 10 Sep 2015 12:23:16 GMT

It's an url, I don't think I can make this a caculated dimension.

Re: Promoting an expression in between dimensions

krishna20 — Thu, 10 Sep 2015 12:42:57 GMT

Hi,

AFAIK It's not possible to place an expression in between the dimensions or vice versa.It's an hierarchy formula pivot chart works . If you drag an expression, all expressions will move and vice versa to dimensions also.