1 Reply Latest reply: Aug 15, 2016 4:30 AM by Marcus Sommer RSS

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

    Jason Zhu

      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

          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