Comparision b/w two years

[ksk278074]

HI experts,

i  am having  2018 and 2019 sales. but now i want to compare the last year december 1st sales and this years december 1st sales .and like wise need to compare the all the date till today.

How to compare the sales ?

[FakeJupiter]

Hi.

Please specify. Do you want to make a straight table with columns date, sales 2019 and sales 2018?
Do you need to compare the sales for each date or month?

How do you want to compare them?

You can make a chart (straight table) as follows:

Dimensions:
Date

Expressions:
1. =sum(Sales2018)
2. =sum(Sales2019)
3. =sum(Sales2019)/sum(Sales2018)-1

[Brett_Bleess]

Be sure to use the Accept as Solution button if any posts meet your information needs, as this gives the posters credit for the assistance and lets other Community Members know what actually worked too.  

Here is a Design Blog post that may be of some further help too:

https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927

Here is the base URL to that area if you wish to do some further searching on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There are hundreds of how-to posts in that area from our internal experts, so you should be able to find ideas for a variety of things there.

Regards,
Brett