4 Replies Latest reply: Apr 12, 2017 12:22 PM by omar bensalem RSS

    Table/Chart with multiple Dimensions and Expressions

    Justin Dallas

      Hello Folks,

       

      In Qlikview, I can have a table/chart with multiple rows, and each row is a different dimension.  And then a different expression is calculated for each row. I have a mockup below.  Whereby the expressions used are all different, ranging from Sum(Sales) to Sum({Year})/Sum({Year-1}).

       

      DesiredOutput.PNG

       

      As of now, the only thing I've been able to get done that looks like this in QlikSense is the following.

       

      CurrentStatus.PNG

       

      Is there anway I can accomplish my goal?

       

      Any help is greatly appreciated.