topic Re: % Display on Bar Chart in QlikView

% Display on Bar Chart

hkg_qlik — Wed, 20 Nov 2013 18:55:35 GMT

Hi all,

I have to display % on each bar as % to be file attached.

Currently the % are divided across the entire chart, but I want to divide it for each bar. Please review the attachments.

Using only one expression:

=count({<[Stock Type] = {'S'}, MFG_SOURCE_LOCATION_ID = {'PR01'}, %FG_FLG = {'Y'}, [Area Name] = >}MSG_PROCESSED_FLG)

and two dimension: Area Name and MSG_PROCESSED_FLG

Regards,

Re: % Display on Bar Chart

Anonymous — Wed, 20 Nov 2013 19:51:38 GMT

try this

dual(count(MSG_PROCESSED_FLG)/count([total<Area Name>MSG_PROCESSED_FLG),

count([MSG_PROCESSED_FLG])) and also inculde set expression asper your requirement

Re: % Display on Bar Chart

Wed, 20 Nov 2013 20:03:48 GMT

In properties, presentation you can check mark Plot Values Inside Segment and In number check (show in percent%) or in expression check relative will help you...