topic Re: Issue in Stack Bar Chart in QlikView

Issue in Stack Bar Chart

sspawar88 — Fri, 24 Jul 2015 10:09:14 GMT

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.

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

Re: Issue in Stack Bar Chart

Fri, 24 Jul 2015 10:10:43 GMT

Hello

Could you send a qvd ?

Re: Issue in Stack Bar Chart

sspawar88 — Fri, 24 Jul 2015 10:17:42 GMT

qvd?

you mean sample QVW

Re: Issue in Stack Bar Chart

awhitfield — Fri, 24 Jul 2015 10:31:44 GMT

Ha ha,

looks like Qlik Sense to me, so it's a ,qvf

Andy

Re: Issue in Stack Bar Chart

sspawar88 — Fri, 24 Jul 2015 10:39:22 GMT

yes andy

but it won't work out in qv and Qs too.

Re: Issue in Stack Bar Chart

awhitfield — Fri, 24 Jul 2015 10:52:48 GMT

which ever; are you uploading one of them?

Andy

Re: Issue in Stack Bar Chart

sspawar88 — Fri, 24 Jul 2015 10:57:46 GMT

Actually i'm working in Qlik sense.

but whenever i came across difficulty in my apps i put same data in QV and QW for get solution for a sample data.

Re: Issue in Stack Bar Chart

awhitfield — Fri, 24 Jul 2015 11:37:00 GMT

OK, please upload either an example qvw OR qvf

Andy

Re: Issue in Stack Bar Chart

sspawar88 — Fri, 24 Jul 2015 11:53:28 GMT

Re: Issue in Stack Bar Chart

mphekin12 — Fri, 24 Jul 2015 12:21:18 GMT

Why don't you set the flag color in the load script? Something like:

if(param_value<=-1 and param_value>=-10, 'RED',

if(param_value<=-10.1 and param_value>=-13.9, 'YELLOW',

if(param_value<=-14 and param_value>=-17.9, 'AMBER',

if(param_value<=-20, 'AMBER',

)

) as param_color;

Re: Issue in Stack Bar Chart

sspawar88 — Fri, 24 Jul 2015 12:32:23 GMT

actually it wont work in Qlik sense and other serious thing is that it works in Qlikview for same script and same data model.

and one more issue is that param_value range is different for different branch_types.

and branch_types locates in branch table.

and param_value in tx_data table.

and these two tables are not connected directly to each other.

how can i get the exact param_color for branch_types?

please suggest me.

Re: Issue in Stack Bar Chart

daniel_kusiak — Fri, 24 Jul 2015 12:45:02 GMT

Count({$}param_value)/Count(total <branch_type>{$}param_value)*100 for each flag=100

You have four flags so it's 400 in stacked chart (green2 is empty).

Same goes with the proportion.

Re: Issue in Stack Bar Chart

sspawar88 — Fri, 24 Jul 2015 13:29:58 GMT

No its not working.

when i put same Band(calculative dimension) and dimension which i mentioned above.

and put your expression in Expression.

it gives same 400%

i want 100% for each branch_type which consist four stack colors for their range counts.