Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sspawar88
Contributor

Issue in stack bar

Hi Community,

I used  Bar chart &

1)dimension-->branch_type

2)calculated dimension-->

if(match(branch_type,'DEPOT','FACTORY','PT','ST'),

(

if(Flag='RED','1',

if(Flag='YELLOW','2',

if(Flag='AMBER','3',

if(Flag='GREEN1','4'

))))))

----------------------------------------------------------------------------

RED--->param_value=<=-1 and param_value=>=-10

YELLOW--->param_value=<=-10.1 and param_value=>=-13.9

AMBER--->param_value=<=-14 and param_value=>=-17.9

GREEN--->param_value=<=-20

(Above are only names of color which are taken by creating Flag in script)

----------------------------------------------------------------------------

3) Expression

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

Count(total <branch_type>{$<param_name={'TEMP'},param_value={'<=-1'}>}param_value)*100

it gives 400% which is wrong.

11111.PNG

it should be 100% and there are diffrerent proportion for stacks for each branch_type