Pivot Table: is there way for a cell to reference what column it is in?
So imagine i have a pivot table as such...
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.
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.