Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hi Nicole
I do not see attachment.
Thanks
Thanks Nicole
I appreciate your correct answer