# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Year comparison in bar chart

Hello,

I asked almost the same question . Sum of the same companies in different years

but now, I want to add something. I want to compare the same periods of these years.

For example,

Today is 28 February. And I want to compare the data from January 1 to February 28 in these years.

Sum({<Company = p({<Year = {"\$(=Max(Year) - 1)"}>})>}Measure)

How this formula can be changed ?

Also,

I want to compare all the companies that are in these years(2016,2017,2018)  If I add another year, for example, 2015, it should compare only the companies which are in all these 4years)

I compare these periods -- Year( as dimension)

but I can't unite it with the formula that calculates the same companies in these years.

1 Solution

Accepted Solutions
MVP

## Re: Year comparison in bar chart

May be try this

=Sum({\$<Date = {">=\$(=YearStart(Today()))<=\$(=MonthEnd(Today()))"}>} FactSoldAmount)

25 Replies
MVP

## Re: Year comparison in bar chart

May be try this

=Sum({\$<Date = {">=\$(=YearStart(Today()))<=\$(=MonthEnd(Today()))"}>} FactSoldAmount)

New Contributor III

## Re: Year comparison in bar chart

It works   Thank you very much !!

I also I have one question. I want to have the same chart, but When I select year in filter  it should change by this logic: if I select 2016,  the chart should be changed by comparing the companies that were only in 2016. When I select 2017 only the companies that were in 2017 should be compared in all of these years.

Is it possible?

MVP

## Re: Year comparison in bar chart

May be this

=Sum({\$<Date = {">=\$(=YearStart(Today()))<=\$(=MonthEnd(Today()))"}>} FactSoldAmount)

New Contributor III

## Re: Year comparison in bar chart

it shows only the year that I select. I want to show all the years' sum, but only the selected year's  companies

MVP

## Re: Year comparison in bar chart

This isn't showing you the previous year (2017) for the companies within the selected year?

New Contributor III

No

MVP

## Re: Year comparison in bar chart

Make sense... try this

=Sum({\$<Date = {">=\$(=YearStart(Today()))<=\$(=MonthEnd(Today()))"}>} FactSoldAmount)

=Sum({\$<Year, Date = {">=\$(=YearStart(AddYears(Today(), -1)))<=\$(=MonthEnd(AddYears(Today(), -1)))"}, Company = p({<Year = {"\$(=Max(Year))"}>})>} FactSoldAmount)