Set analysis in Qlikview

[sspawar88]

Hi, Here i'm in Middle of some critical set analysis

i have region_name

1)WEST

2)NORTH

3) EAST

4) SOUTH

branch_type

1)PT

2)DEPOT

Four groups of Temperature  for region  (A)

above -10

-10.1 to -13.9

-14 to -17.9

-22 & below

Groups of Temperature for PT And DEPOT

  PT   (B)                                               

above -10

-10.1 to -13.9

-14 to -17.9

-18 & below

  DEPOT  (C)

above -10

-10.1 to -13.9

-14 to -17.9

-20 & below

Question first--> i want four(now according to database it can show only for WEST) stack bar chart for all region in which

Percentage as like this--->

Count({$<param_name={'Temperature'}, region_name={'WEST'}>}param_value)

/count(total{$<param_name={'Temperature'}>}param_value)*100

but in four groups of temperature see above for REGION (A) in stack BAR

Question two-->

in another Bar chart for stack style

same for branch_type but

how i can give those grouping (B)&(C) which are different for ST and DEPOT.?

How can i calculate percentage for ST and DEPOT in same Stack Bar chart for Different Temperature GROUP (B)&(C)?

i attached sample data QVW.

[MK_QSL · Accepted solution]

Create a bar Chart

Calculated Dimension

=IF(param_value >= -10, 'Above -10',

  If(param_value < -10 and param_value > -14, '-10 to -13.9',

  If(param_value <= -14 and param_value > -18, '-14 to -17.9',

  If(param_value <= -18 and param_value > -22, '-18 to -21.0',

  'Below -22'))))

  Expression

  already given by you...

[sspawar88]

How can i use calculated dimension for PT And DEPOT and their DIFFERENT GROUPS of TEMPERATURE at a tIme in my Bar chart of stack style  ?

What i need to change in my EXPRESSION to calculate Percentage for both PT And DEPOT ?

Suppose i want to give color for group of temperature in my stack bar chart so where i have to put color function?