6 Replies Latest reply: Nov 14, 2016 7:25 AM by Chanty 4u

# use math function with set analysis

hi

how can i create this set analysis:

count({<sum(sales)>{5000}>}ID)

????

• ###### Re: use math function with set analysis

this is from Qlik help

sum( {\$<Customer = {“=Sum({1<Year = {2007}>} Sales ) > 1000000”}>} Sales )

returns the sales for current selection, but with a new selection in the “Customer” field: only customers who during 2007 had a total sales of more than 1000000.

sum( {\$<ID = {“=Sum(sales ) > 5000”}>} ID )

• ###### Re: use math function with set analysis

small change in maxgro Exp

try with single code

sum( {\$<ID = {'=Sum(sales ) > 5000'}>} ID )

• ###### Re: use math function with set analysis

thank you

i used this and it was ok

Count(Aggr(if(sum(sales)<5000,ID),ID))

• ###### Re: use math function with set analysis

Good to hear

• ###### Re: use math function with set analysis

single quote is for literal

double for search

A Primer on Set Analysis

• ###### Re: use math function with set analysis

Thanks:)