Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

agigliotti
Honored Contributor II

How to get first pivot dimension field name

Hello,

I'm in trouble with an expression in pivot table because I'd have to know the first dimension field name (ex customer) to change definition accordingly.

That's because I need to allow pivoting.

Of course it would be great if I could conditionally allow pivoting for a single dimension.

Please let me know how I can manage this needed.

Many thanks in advance.

Best Regards

Andrea

5 Replies
MVP
MVP

Re: How to get first pivot dimension field name

GetObjectField(0)

trdandamudi
Honored Contributor

Re: How to get first pivot dimension field name

Can you please share a sample app and explain clearly what you need, so that we can take a look and come up with a solution.

miguelbraga
Valued Contributor III

Re: How to get first pivot dimension field name

Hi Andrea,

I can't seem to understand your needs without you make a more compreenhsive question. Please describe it giving us a image or explain in a document what you really need. There may be a way we can help you quickly. You can also make in that document a design of your required solution.

Regards,

MB

agigliotti
Honored Contributor II

Re: How to get first pivot dimension field name

Many thanks to all of you for your quickly support.

agigliotti
Honored Contributor II

Re: How to get first pivot dimension field name

It's useful but it give me always the first chart dimension regardless the enable conditional settings.

Therefore the GetObjectField(0) function returns the first pivot dimension name even if it's hidden because its conditional expression.

Community Browser