Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
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
paulyeo11
Master
Master
Author

Hi All

Enclosed my QVW

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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))