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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis with nested function and greater than value

Hi all,

I have to find sum of price, where round(price,1) >0 using set analysis.

1 Reply
sunny_talwar

What is the dimension where you are checking round(price, 1) > 0? May be try this

Sum({<Dimension = {"=round(Sum(price), 1) > 0"}>} price)

or this

Sum(RangeMax(round(price, 1), 0))