use math function with set analysis

[omid5ive]

hi

how can i create this set analysis:

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

????

[maxgro]

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 )

[Chanty4u · Accepted solution]

small change in maxgro Exp

try with single code

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

[omid5ive]

thank you

i used this and it was ok

but your answer is true

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

[Chanty4u]

Good to hear

[maxgro]

single quote is for literal

double for search

A Primer on Set Analysis

[Chanty4u]

maxgro

Thanks:)