Set Analysis Help

[#1]

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.

[tresesco]

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

[rubenmarin]

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

[MK_QSL]

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]

Try this

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

[maxgro]

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

[#7]

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