topic Re: Set analysis in QlikView

Set analysis

sspawar88 — Thu, 09 Jul 2015 11:47:03 GMT

Hi Community,

I'm working on bar chart and have a dimension region_name consists of NORTH,EAST,WEST & SOUTH. When we use total function in set analysis as following:

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count(total <region_name>{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)

So what exactly it is calculating at numerator and denominator?

Is it calculating for whole four region together at denominator or it takes only selected Region count?

Re: Set analysis

swuehl — Thu, 09 Jul 2015 11:51:58 GMT

Please have a look at:

The Aggregation Scope

Re: Set analysis

MayilVahanan — Thu, 09 Jul 2015 11:54:01 GMT

Hi Satish,

Short note: it takes only selected Region count

Brief:

Suppose, you have 2 dimension, Region and State,

Region State Sales

XX YY 100

XX XZ 200

YY WW 400

Count(total <region_name>{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)

Region State Sales Denominator (Sum(total <Region> Sales))

XX YY 100 300

XX XZ 200 300

YY WW 400 400

Re: Set analysis

Thu, 09 Jul 2015 12:00:24 GMT

If you have region_name as dimension,

Numerator - Counts the param_value group by available dimensions in the chart and for param_name equals to 'Temparature' and param_value <= -1

Denominator - Returns the total param_value for each region ignoring all the other dimensions. If any region is selected, only that region values will be shown and for param_name equals to 'Temparature' and param_value <= -1

Regards,

KKR

Re: Set analysis

qlikviewwizard — Fri, 10 Jul 2015 02:37:11 GMT

Hi Sspawar88

Can you provide some sample data for better understanding the issue and provide efficient solution.

Thanks.