Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Multiple Set Analysis In an Equation

Hello I am attempting to structure an equation with a couple of conditions.

The first equation is:

=NUM(Sum({<fmlyGRP= {'Juices'}>}salesTTL), '$##,###.##')

and I want to include this as well:

=NUM(Sum({<Location = {'Food Truck'}>}salesTTL), '$##,###.##')

I am attempting to find the total sales where the 'Location' is equal to 'Food Truck' and the 'fmlyGRP' is equal to 'Juices'

How would this be structured?

1 Solution

Accepted Solutions
Anonymous
Not applicable

=NUM(Sum({<fmlyGRP= {'Juices'},Location = {'Food Truck'}>}salesTTL), '$##,###.##')

View solution in original post

1 Reply
Anonymous
Not applicable

=NUM(Sum({<fmlyGRP= {'Juices'},Location = {'Food Truck'}>}salesTTL), '$##,###.##')