Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

How to make my Revenue display +ve Sign ?

Hi All

I use the below expression for TABLE (1) list the total amount for Exp IS WORKING FINE :-

Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},P_Exp={P_Exp}>}Amount*1)/1000, SOURCE))
,
$(vMoneyFormatK))

I use the below expression for TABLE (2) list the total amount for Revenue IS WORKING FINE , but i like to make the sign from -ve to +ve :-

Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},P_Revenue={P_Revenue}>}Amount*1)/1000, SOURCE))
,
$(vMoneyFormatK))

Paul Yeo

2 Replies
Highlighted
Master
Master

Re: How to make my Revenue display +ve Sign ?

Hi All

Enclosed my QVW

Highlighted
Partner
Partner

Re: How to make my Revenue display +ve Sign ?

Try this:

Money(
fabs(Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},P_Revenue={P_Revenue}>}Amount*1)/1000, SOURCE)))
,
$(vMoneyFormatK))