topic Re: how to show sales difference for current month and previous month based on selection? in QlikView

how to show sales difference for current month and previous month based on selection?

Akina0929 — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

I have following table

month, sales

jan,200

feb,400

mar,750

apr,900

may,1023

jun,1200

I want to show sales difference in Text box . if i select march it should show difference from march sales to feb sales,if i select jun it should show it should show difference from jun to may.based on current it should display.please help me.

Regards

Anji

Re: how to show sales difference for current month and previous month based on selection?

tresB — Fri, 08 Dec 2017 05:24:29 GMT

Do you have year, date fields too? If yes, try to share some data/app with such data.

Re: how to show sales difference for current month and previous month based on selection?

Anonymous — Fri, 08 Dec 2017 05:31:24 GMT

You can Show it with the Help of Two Text Box for current and Previous month using the Set Analysis

Sum({$<Month={$(=Max(Months))}>}sales) // For Current Selection

Sum({$<Months={$(=Max(Months)-1)}>}Sales) // For Previous month

Re: how to show sales difference for current month and previous month based on selection?

vikasdesai — Fri, 08 Dec 2017 06:14:42 GMT

Hello,

Use following expression to calulate the sales difference for current month and previous month based on selection

Sum({$<Month={$(=Max(Months))}>}sales) - Sum({$<Month={$(=Max(Months)-1)}>}sales)

Regards,

Vikas

Re: how to show sales difference for current month and previous month based on selection?

devarasu07 — Fri, 08 Dec 2017 06:23:15 GMT

Hi Anji,

Refer to the attached sample, best way to derive using master calendar and set analysis method, (real time u should have data in date format with historical period so u have to update this expression).

Fact:
load  * Inline [
month, sales
jan,200
feb,400
mar,750
apr,900
may,1023
jun,1200];
[Month Sort]:
load * inline [
monthno,month
1,jan
2,feb
3,mar
4,apr
5,may
6,jun];