Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Help

Hi,

How do we use and condition in set analysis?

I want to display the sum(Value) where Category='A',  Type='B', Place not equal to 'C' and Year>2013.

6 Replies
tresesco
MVP
MVP

Sum({<Category={'A'}, Type={'B'}, Place -={'C'}, Year={'>2013'}>}Value)

rubenmarin

sum({<Category={'A'},  Type={'B'}, Place-={'C'}, Year={">2013"}>} Value)

MK_QSL
MVP
MVP

SUM({$<Category = {'A'}, Type = {'B'}, Place -= {'C'}, Year = {'>2013'}>}Value)

Or

SUM({$<Category = {'A'}, Type = {'B'}, Place -= {'C'}, Year = {'>$(=Year(Today())-1)'}>}Value)

er_mohit
Master II
Master II

Try this


Sum({<Category={'A'},Type={'B'},Place-={'C'},Year={'>2013'}>}Value)

maxgro
MVP
MVP

sum( {$<Category={A}, Type={B}, Place=-{C}, Year = {“>2013”}>} Value)

or

sum( {$<Category={A}, Type={B}, Place-={C}, Year = {“>2013”}>} Value)


no need to quote

Not applicable
Author

Hi

I find this online tool great for set analysis, and really helps you understand how to build it.

Set Analysis Wizard for QlikView | qlikblog.at