topic Re: Subtract Previous month value from Present month value in QlikView

Subtract Previous month value from Present month value

Anonymous — Tue, 19 Sep 2017 20:30:27 GMT

Hi All

Base on MonthYear selection(on Left) I want to see the Selected Month Value - Previous Month Value for Selected Month

So let see below two scenario

Scenario 1: Jun-2012

Scenario 2: Juj-2012

In case of Scenario 2(if I Select Jul-2012) I want to show for each and every cell

1. ▲(alt + 30) if(Jul-2012 > Jun-2012) OR

2. ▼(alt + 31) if(Jul-2012 < Jun-2012)

3. else Blank

Note: test.qvw attached

Thanks in advance

Re: Subtract Previous month value from Present month value

Nicole-Smith — Tue, 19 Sep 2017 20:51:59 GMT

I believe this expression accomplishes what you're asking:

if(
/* Selected Month */ sum(InvoiceValue) - 
/* Previous Month */ sum({<MonthYear={$(=chr(39) & date(AddMonths(MonthYear, -1), 'MMM-YYYY') & chr(39))}>}InvoiceValue)
  > 0, '▲',
if(
/* Selected Month */ sum(InvoiceValue) - 
/* Previous Month */ sum({<MonthYear={$(=chr(39) & date(AddMonths(MonthYear, -1), 'MMM-YYYY') & chr(39))}>}InvoiceValue)
  < 0, '▼'
, ''))

I've also attached your test file with this expression included.

Re: Subtract Previous month value from Present month value

Anonymous — Tue, 19 Sep 2017 21:06:59 GMT

Hi Nicole

I do not see attachment.

Thanks

Re: Subtract Previous month value from Present month value

Anonymous — Tue, 19 Sep 2017 21:13:06 GMT

Thanks Nicole

I appreciate your correct answer