topic Re: Comparision b/w two years in QlikView

Comparision b/w two years

ksk278074 — Sat, 16 Nov 2024 01:41:02 GMT

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 ?

Re: Comparision b/w two years

FakeJupiter — Tue, 17 Dec 2019 14:02:15 GMT

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

Re: Comparision b/w two years

Brett_Bleess — Mon, 23 Dec 2019 18:44:20 GMT

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