Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
marcus_sommer

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