topic Re: Set Analysis Help in QlikView

Set Analysis Help

Thu, 18 Sep 2014 11:31:33 GMT

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.

tresB — Thu, 18 Sep 2014 11:33:19 GMT

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

rubenmarin — Thu, 18 Sep 2014 11:34:12 GMT

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

MK_QSL — Thu, 18 Sep 2014 11:34:12 GMT

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

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

er_mohit — Thu, 18 Sep 2014 11:34:16 GMT

Try this

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

maxgro — Thu, 18 Sep 2014 11:35:43 GMT

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

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

no need to quote

Thu, 18 Sep 2014 11:45:54 GMT

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