Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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()))