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: 
omid5ive
Creator II
Creator II

use math function with set analysis

hi

how can i create this set analysis:

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

????

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

small change in maxgro Exp

try with single code

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

View solution in original post

6 Replies
maxgro
MVP
MVP

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
MVP
MVP

small change in maxgro Exp

try with single code

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

omid5ive
Creator II
Creator II
Author

thank you

i used this and it was ok

but your answer is true

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

Chanty4u
MVP
MVP

Good to hear

maxgro
MVP
MVP

single quote is for literal

double for search

A Primer on Set Analysis

Chanty4u
MVP
MVP

maxgro

Thanks:)