Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Announcements

Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution.
**READ ALL ABOUT IT!**

- Qlik Community
- :
- All Forums
- :
- QlikView App Dev
- :
- Sum problem

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

dradoikov

Partner - Contributor III

2010-03-25
03:34 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sum problem

Hi,

Hello,

I have the following problem with this expression:

sum({$<AccountingStateMonth ={1}>} AccountInitalDebit)+ Sum(if(AccountingStateMonth<=Month1,AccountMonthDebit))- sum({$<AccountingStateMonth ={1}>} AccountInitalCredit) - Sum(if(AccountingStateMonth<=Month1,AccountMonthCredit)),0)

sum({$<AccountingStateMonth ={1}>} AccountInitalDebit)+ Sum(if(AccountingStateMonth<=Month1,AccountMonthDebit))- sum({$<AccountingStateMonth ={1}>} AccountInitalCredit) - Sum(if(AccountingStateMonth<=Month1,AccountMonthCredit)),0)

376 Views

2 Replies

Oleg_Troyansky

Partner Ambassador/MVP

2010-03-25
08:08 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

would be easier if you could post a sample...

179 Views

michael_anthony

Creator II

2010-03-26
06:58 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Daniel,

Your question is a bit confusing.

The expression for Column 1 and Column 2 in your post are both the same. I'm guessing though that Column 1 is supposed to show the account balance if it is positive, and 0 if -ve. Column 2 is opposite - show balance if -ve, or 0 if +ve.

If that's the case, either column 1 or column 2 will always be zero. So dividing Column 1 / Column 2 will always return 0.

What are you trying to calculate?

179 Views