Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Pivot Table: is there way for a cell to reference what column it is in?

So imagine i have a pivot table as such...

                         Column_Name1     Column_Name2

Row_Name1               x                              y         

Row_Name2               a                              b

Is there a way for cell X to know what column it is in, ie  what column_name1 is? I want to be able to include that value in my measure expression. Basically i want the measure expression to vary depending on column values.

Thank you!

1 Reply

Re: Pivot Table: is there way for a cell to reference what column it is in?

AFAIK there is no way to get the expression-name - at least not with qlikview unless by using macros - and I doubt that qlik sense had here already more capabilities. But if you replaced the expressions with a dimension (whose values could be queried) you could react on them and switch the expressions. Whereby I think this won't be trivial and and will probably have some disadvantages so that other approaches which work with conditions, for example to certain selections, might be easier.

- Marcus

Community Browser