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: 
vijetas42
Specialist
Specialist

Set Analysis

Hi,

I want to write an expression with some filer and excluding other one

e.g. sum({<Product={"=sum(Value)>0"}>}sales) here i need sales for product where value for each product should be grater than 0 and it should not affected by any other filter selection.

Thanks!

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Add a 1 (one) in front to ignore all other selections: sum({1<Product={"=sum({1}Value)>0"}>}sales)


talk is cheap, supply exceeds demand