Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanBarrick
Creator
Creator

Accumulation with Set Analysis

I have an equation: 

=RangeSum(Above(Sum{$<PRICE >{"0.00"},}>}(QTY),0,RowNo()))

 

with which I am trying to get the aggregating QTY of tickets where the price is greater than 0.00. I cannot get the editor to accept the structure of my equation. Looking for suggestions on how to correct.

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

maybe soemthing like this?

 

RangeSum(Above(Sum(
{< PRICE ={">0.00"}>}QTY
),0,RowNo()))

View solution in original post

2 Replies
sunny_talwar

Try this

=RangeSum(Above(Sum{$<PRICE = {">0.00"}>} QTY), 0, RowNo()))
dplr-rn
Partner - Master III
Partner - Master III

maybe soemthing like this?

 

RangeSum(Above(Sum(
{< PRICE ={">0.00"}>}QTY
),0,RowNo()))