Re: Promoting an expression in between dimensions - Qlik Community

Report Inappropriate Content · ‎2015-09-10

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

PrashantSangle · ‎2015-09-10

Hi,

Hold and Drag it upto desired location.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

gautik92 · ‎2015-09-10

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

Report Inappropriate Content · ‎2015-09-10

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

Please help.

gautik92 · ‎2015-09-10

can you send sample qvw?

jonathandienst · ‎2015-09-10

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?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2015-09-10

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

krishna20 · ‎2015-09-10

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.