Set analysis

sspawar88 — Thu, 02 Jul 2015 14:45:41 GMT

Hi Community,

Here i'm working on Bar Chart & calculate percentage for region.

i have Temperature Database so here i'm calculating percentage for Temperature as

Count of temperature less than -1 for specific region e.g WEST-----numerator

all count of temperature less than -1--------------------------------------------denominator

here below i tried some thing but it gives strange result

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

Count(Total{$<param_name={'Temperature'},region_name=,branch_type=,param_value={'<=-1'}>}param_value)*100

and same in another bar chart for branch_type

Count of temperature less than -1 for specific branch_type e.g FACTORY-----numerator

all count of temperature less than -1--------------------------------------------denominator

Can same formulae works on both chart?

and also if i select on any branch_type or Region it has to effect on another chart.

suppose i select on WEST in region chart..it should gives the percentage for all branch_type in WEST Region in branch_type chart or inverslly suppose i select on FACTORY in branch_type chart..it should gives the percentage for FACTORY for all Regions in Region Chart.

What will be this two formulaes...same or different..how?

Set analysis

Re: Set analysis

MK_QSL — Thu, 02 Jul 2015 15:22:41 GMT

You are bypassing region_name= in set analysis so region selection would not affect this chart.

topic Re: Set analysis in QlikView

Set analysis

Re: Set analysis