Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Highlighted
Valued Contributor II

Table/Chart with multiple Dimensions and Expressions

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.

4 Replies
Highlighted

Re: Table/Chart with multiple Dimensions and Expressions

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

Highlighted
Valued Contributor II

Re: Table/Chart with multiple Dimensions and Expressions

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

Highlighted

Re: Table/Chart with multiple Dimensions and Expressions

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

Highlighted
Partner
Partner

Re: Table/Chart with multiple Dimensions and Expressions

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