Set analysis

[sspawar88]

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?

[swuehl]

Please have a look at:

The Aggregation Scope

[MayilVahanan]

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

[#4]

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

[qlikviewwizard]

Hi Sspawar88

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

Thanks.