Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with sum in listBox

Hello,

In a listBox, I want to calculate the sum of multiple entities based on the following formula:
if (X = 200 OR Y = 381, sum (if (Z = 4, amount, 0)), 0)
listBox does not work with SUM. while the same expression works well in another table in the same sheet.

1 Solution

Accepted Solutions
MVP
MVP

Re: Problem with sum in listBox

You could achieve similar output with proper use of Aggr(). Try to share a sample qvw with sample data explaining expected output.

3 Replies
rido1421
Contributor III

Re: Problem with sum in listBox

Hi

Can you not do your formula in the script and name it as a field?

MVP
MVP

Re: Problem with sum in listBox

You could achieve similar output with proper use of Aggr(). Try to share a sample qvw with sample data explaining expected output.

Not applicable

Re: Problem with sum in listBox

Aggr() seems resolving the problem. your help was very helpful, thank you.