# QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Contributor II

## use math function with set analysis

hi

how can i create this set analysis:

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

????

Tags (1)
1 Solution

Accepted Solutions
Esteemed Contributor III

## Re: use math function with set analysis

small change in maxgro Exp

try with single code

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

6 Replies
MVP

## Re: use math function with set analysis

this is from Qlik help

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-m...

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.

maybe for your expression

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

Esteemed Contributor III

## Re: use math function with set analysis

small change in maxgro Exp

try with single code

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

Contributor II

## Re: use math function with set analysis

thank you

i used this and it was ok

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

Esteemed Contributor III

Good to hear

MVP

## Re: use math function with set analysis

single quote is for literal

double for search

A Primer on Set Analysis

Esteemed Contributor III

Thanks