topic Show Current Month and Previous Month Sales based on Date selection in App Development

Show Current Month and Previous Month Sales based on Date selection

bhargavikn — Fri, 15 Nov 2024 21:10:32 GMT

Hi All,

I'm trying to get previous month and current month sales measures in Qlik Sense Table.

Current month sales is working fine as per selection. But previous month sales are showing blank until I select both Current and Previous month dates.

Example:

Product	Date	Sales
Apple	31-01-2023	100
Apple	28-02-2023	200
Apple	31-03-2023	300
Banana	31-01-2023	400
Banana	28-02-2023	500
Banana	31-03-2023	600

Expected Output:

Product	Sum(Selected Date Sales) 31-03-2023	Sum(Previous Date Sales) 28-02-2023
Apple	300	200
Banana	600	400

Expressions tried:

Current Month Sales: sum( TOTAL { <[Date]={"$(=date(max([Date]),'DD-MM-YYYY'))"}>}Sales)
Previous Month Sales: sum( TOTAL { <[Date]={"$(=date(floor(monthend(max([Date]),-1)),'DD-MM-YYYY'))"}>}Sales)

Issue : Getting Previous month sales only after selecting 2 months. For example, If I selected 31-05-2023, showing only Current month sales and previous month is blank. But If I select 31-05-2023 and 30-04-2023, Showing Current and Previous month sales.

Please help me to resolve the issue using chart expressions.

Thank you.

Re: Show Current Month and Previous Month Sales based on Date selection

md_talib — Thu, 14 Dec 2023 12:48:17 GMT

You need to make two 4 variable for date function

2 for current month and 2 for previous month

for current Month

vCalMinDate =date(MonthStart(Max(Posting_Date)),'DD/MM/YYYY')

vCalMaxDate =date(Max(Posting_Date) ,'DD/MM/YYYY')

for Previous Month

vPMCalMinDate =date(addmonths(MonthStart(Max(Posting_Date)),-1),'DD/MM/YYYY')

vPMCalMaxDate =date(addmonths(Max(Posting_Date) ,-1),'DD/MM/YYYY')

then your selection will work perfect.

Re: Show Current Month and Previous Month Sales based on Date selection

bhargavikn — Fri, 15 Dec 2023 05:22:46 GMT

Thank you for your response.

In data, I have only one date that is Month end date for each month and need value based on that current date and previous date.

I'm unable to understand your logic. Could you please provide sample expression.

Thank you again.

Re: Show Current Month and Previous Month Sales based on Date selection

bhargavikn — Mon, 18 Dec 2023 08:11:40 GMT

Hello, Can someone suggest me on the issue please.

Thank you.

Re: Show Current Month and Previous Month Sales based on Date selection

md_talib — Fri, 12 Jan 2024 12:39:20 GMT

you need to create a master calendar which will create the dates for the range.