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: 
Not applicable

Creating Set Analysis expression

Hi,

iam unable to create the set analysis expression for this

1)  Sum of all sales where office=4 and CategoryName is Babywear.

2)  Sum of all sales where office=4 and CategoryName is children's wear

please help me out for this expression.

Thanks,

Sudha Banakar

1 Reply
Nicole-Smith

1) sum({<office={4}, CategoryName = {'Babywear'}>}sales)

2) sum({<office={4}, CategoryName = {"children's wear"}>}sales)