Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

omid5ive
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
sureshqv
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
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 )

sureshqv
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 )

omid5ive
Contributor II

Re: use math function with set analysis

thank you

i used this and it was ok

but your answer is true

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

sureshqv
Esteemed Contributor III

Re: use math function with set analysis

Good to hear

MVP
MVP

Re: use math function with set analysis

single quote is for literal

double for search

A Primer on Set Analysis

sureshqv
Esteemed Contributor III

Re: use math function with set analysis

maxgro

ThanksSmiley Happy