Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
claudialet
New Contributor III

How to return negative numbers from sum of positive numbers

Here us my expression . It is calculated as positive but I need to show them as negative in a bar chart. The money format is not working

Sum({$<ScenarioVersionID = {$(CurrentScenarioID)}, Source = {'Earnings'}>} if(wildmatch(Line,'5a','5b','5c'), Amount))

Here is my number format :

Money    $#,##0;($#,##0)

1 Solution

Accepted Solutions

Re: How to return negative numbers from sum of positive numbers

What if you do this

-Sum({$<ScenarioVersionID = {$(CurrentScenarioID)}, Source = {'Earnings'}, Line = {'5a', '5b', '5c'}>} Amount)

1 Reply

Re: How to return negative numbers from sum of positive numbers

What if you do this

-Sum({$<ScenarioVersionID = {$(CurrentScenarioID)}, Source = {'Earnings'}, Line = {'5a', '5b', '5c'}>} Amount)