Trigger when user replaces dimensions positions in Pivot table when AllowPivoting=true

[plamen_alexiev]

Hi all,

There are in Qlikview trigger when end user replaces dimensions in pivot table when Allow Pivoting check box is set to enable dimensions pivoting?

Plamen Alexiev

[MindaugasBacius]

I am guessing you're talking about this option:

-Chart Properties > Dimensions > Enable Conditional:

     Index('|' & Concat(_Dimensions, '|') & '|', '|1|')

You might find useful this thread:

Dynamic Dimension selection for a pivot table

[plamen_alexiev]

No Mr. Bacius,

I't not about view-hide column in Pivot table...

When in Pivot table Allow Pivoting = True the end user can promotes / demotes but only dimensions. My question is; Is there trigger to catch event when user replaces dimesions.

Suppose we have tree dimensions 0-Currency;1-InstrumentType;2-Position in Pivot table. If you enable Pivoting (Allow Pivoting is checked) user can change dimensions 0-InstrumentType;1-Currency;2-Position. This is managed by drag-drop dimension columns......

I will to find moment the user do this.....

Pl.Alexiev

[andrey_krylov]

Hi, as I know there is no such trigger

[plamen_alexiev]

So,

The single possible measure is yo disable Pivoting?

Pl.Alexiev

[andrey_krylov]

I cannot say. Why do you need this trigger? GetObjectField(0,'CH01') returns the Field name of the first dimension, maybe it may help you.

[plamen_alexiev]

OK,

But, how I can take the moment when dimensions are pre-ordering?

Pl. Alexiev

[plamen_alexiev]

Здравствуй Андрей,

Я болгар Пламен Алексиев. Если ( не имею е-оборотное и е-ри) Ви рускиий я хочу общатся с Вами, конечно если Ви хотите.

Now in english:

In Pivot Table Chart i have Expression, which calculate and aggregate depends on dimension level. When User changes dimension order (I will to allow pivoting), I also must change aggregation formula. It is the reason to catch a trigger when user promote / demote dimensions.

Pl. Alexiev

[andrey_krylov]

Добрый день, Пламен!)

Посмотри во вложении, там возможный вариант решения твоего вопроса.

Now in english:)

If you share the expression then it's possible we'll find another solution

[plamen_alexiev]

Thank you Andrey, (большое спосибо),

Your suggestions is valuable. I will mark it as helpfull....

Pl.Alexiev