Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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