Table/Chart with multiple Dimensions and Expressions

[JustinDallas]

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}).

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

Is there anway I can accomplish my goal?

Any help is greatly appreciated.

[sunny_talwar]

May be like this

2017

Sum({<Year = {$(=Max(Year))}>} Sales)

2016

Sum({<Year = {$(=Max(Year)-1)}>} Sales)

YoY

Sum({<Year = {$(=Max(Year))}>} Sales)/Sum({<Year = {$(=Max(Year)-1)}>} Sales) - 1

[JustinDallas]

I'm not having a problem with the calculation, I'm having an issue of where the calculation should go in the UI component.

Table/Chart with multiple Dimensions and Expressions

[sunny_talwar]

As a measure in your table object or are you looking for something else?

[OmarBenSalem]

As a dimension choose:

ValueList('2017 Sales YTD', '2016 Sales YTD','YOY','Margin')

as a measure:

if(ValueList('2017 Sales YTD', '2016 Sales YTD','YOY','Margin')='2017 Sales YTD', expression for YTD 2017,

if(ValueList('2017 Sales YTD', '2016 Sales YTD','YOY','Margin')='2016 Sales YTD', expression for YTD 2016,

if(ValueList('2017 Sales YTD', '2016 Sales YTD','YOY','Margin')='YOY', expression for YOY,

if(ValueList('2017 Sales YTD', '2016 Sales YTD','YOY','Margin')='Margin', expression for Margin))))

then add as a column: Your month field:

You'll have the output you're looking for