topic Re: Set analysis Challenge in QlikView

Set analysis in Qlikview

sspawar88 — Wed, 17 Jun 2015 05:59:32 GMT

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.

Re: Set analysis Challenge

MK_QSL — Wed, 17 Jun 2015 06:21:31 GMT

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...

Re: Set analysis in Qlikview

sspawar88 — Wed, 17 Jun 2015 10:26:33 GMT

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?