topic Re: stacked barchart in QlikView

stacked barchart

Anonymous — Thu, 11 Sep 2014 09:35:04 GMT

I have stacked bar chart with 2 dimension and one expression.

In above chart we want to display percentage for bars 100% similarly for all the bars.

Suggest some ideas, if i am creating a different charts for each dimension field for ex: C(dimension field in chart) then i am getting the output but it is not a suitable way. As per requirement it should display 100% for all dimension field and in same chart.

Thanks

Manish Madan

Re: stacked barchart

MK_QSL — Thu, 11 Sep 2014 09:41:22 GMT

Your Expression should be like below

SUM(YourMeasureFieldName)/SUM(Total <YourFirstDimension>YourMeasureFieldName)

Re: Re: stacked barchart

Anonymous — Thu, 11 Sep 2014 12:49:26 GMT

Hi Manish

Please find attached sample app.

Can you please help.

Thanks

Re: stacked barchart

MK_QSL — Thu, 11 Sep 2014 12:53:05 GMT

Attachment Missing !!

Or may be for authentication 😞

Re: Re: stacked barchart

Anonymous — Thu, 11 Sep 2014 13:15:19 GMT

sorry,

PFA..

Re: stacked barchart

MK_QSL — Thu, 11 Sep 2014 13:25:57 GMT

Not clear from you apps. What you want to achieve? Please clarify !

Update : use below expressions

=count({<[Entity_Emp_Scale]= >}if((Zone)='A',Entity_Emp_Scale))/count(TOTAL {<[Entity_Emp_Scale]= >}if((Zone)='A',Entity_Emp_Scale))

=count({<[Entity_Emp_Scale]= >}if((Zone)='M',Entity_Emp_Scale))/count(TOTAL {<[Entity_Emp_Scale]= >}if((Zone)='M',Entity_Emp_Scale))

=count({<[Entity_Emp_Scale]= >}if((Zone)='A',Entity_Emp_Scale))/count(TOTAL <Zone> {<[Entity_Emp_Scale]= >}if((Zone)='A',Entity_Emp_Scale))

=count({<[Entity_Emp_Scale]= >}if((Zone)='M',Entity_Emp_Scale))/count(TOTAL <Zone> {<[Entity_Emp_Scale]= >}if((Zone)='M',Entity_Emp_Scale))

or Single Expression (Thanks Ruben Marin)

COUNT({<Zone = {'A','M'}>}Entity_Emp_Scale)/COUNT(TOTAL <Zone> {<Zone = {'A','M'}>}Entity_Emp_Scale)

Re: Re: Re: stacked barchart

rubenmarin — Thu, 11 Sep 2014 13:29:51 GMT

Hi Manish,

Ckeck attached file and see if that's what you want.

I used the formula Manish said and with a bit changes on dimensions and expressions.

Re: Re: stacked barchart

Anonymous — Thu, 11 Sep 2014 13:37:13 GMT

ok..

I have attached another app same as screenshot i shared earlier in that i want for each dimension field data share appear out of 100%.

Don't know why i am facing issue in uploading the file,can u share ur email address.

Re: stacked barchart

MK_QSL — Thu, 11 Sep 2014 13:42:21 GMT

Use below expression

Count(Entity_Emp_Scale)/Count(Total <Zone> Entity_Emp_Scale)

Untick Relative...

go to number tab and tick show in percentage

UPDATE : File Enclosed..

Re: Re: stacked barchart

Anonymous — Thu, 11 Sep 2014 13:45:50 GMT

Hi Ruben,

can you please give a try with my 2nd attachment.

Thanks

Manish Madan

Re: Re: stacked barchart

Anonymous — Thu, 11 Sep 2014 13:53:25 GMT

I tried the same,it is working as per expectation.

Many Thanks

Re: stacked barchart

MK_QSL — Thu, 11 Sep 2014 13:55:09 GMT

Manish Madan.... Don't know what was your exact requirement?

i.e. based on 1st Attachement or based on 2nd Attachement...

If based on 2nd Attachement.... check my very first reply...

SUM(YourMeasureFieldName)/SUM(Total <YourFirstDimension>YourMeasureFieldName)

This was enough for your question...

Re: stacked barchart

Anonymous — Thu, 11 Sep 2014 14:30:57 GMT

Hi Manish,

Sorry i didn't notice that same logic is implemented by Ruben as well.

You both are really helpful,thanks again .

Re: stacked barchart

MK_QSL — Thu, 11 Sep 2014 15:12:10 GMT

I didn't write to mark my question correct. My only objective is to let you know that this problem could have been solved at the very early stage, if you had read answer properly... I am here to learn and to help other members of community.... Earning point is not my GOAL !