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

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

Mon, 15 Aug 2016 07:08:24 GMT

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!

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

marcus_sommer — Mon, 15 Aug 2016 08:30:21 GMT

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