Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

drudd75077
New Contributor II

how to add a two measure value to the same dimension

I have a plan of projects for 2018 (red), I also have charged time for 2018 (Blue)

I have an issue because we have some projects from 2017 that charged in 2018 (projects from last year that carried over). I want to show how many hours have been used this year in comparison to the hours we have planned for projects this year. So I want the total of hours charged this year in comparison with projects planned for this year

TLDR: I want the two blue bars summed and represented next to the red bar with only the 2018 dimension showing.

2018-05-24 16_52_57-Qlik Sense Desktop.png

Any help would be great!

1 Solution

Accepted Solutions
drudd75077
New Contributor II

Re: how to add a two measure value to the same dimension

So I figured out a way in which it would work for my situation.

I combined the dimensions using an expression. Basically if my year equaled 2017 or 2016 I made the if statement reassign them to 2018.

This showed all my data in one dimension.

=if(Year='2017','2018',if(Year='2016','2018','2018'))

1 Reply
drudd75077
New Contributor II

Re: how to add a two measure value to the same dimension

So I figured out a way in which it would work for my situation.

I combined the dimensions using an expression. Basically if my year equaled 2017 or 2016 I made the if statement reassign them to 2018.

This showed all my data in one dimension.

=if(Year='2017','2018',if(Year='2016','2018','2018'))