topic Calculating percentage value in a chart in QlikView

Calculating percentage value in a chart

Fri, 10 Feb 2012 10:24:00 GMT

Hi,

I have one bar chart with two dimensions

1) MonthYear (which has values like Jan 2010, Feb 2010, etc)

2) Type (which has values 'A', 'B' and 'C')

The expression shows the count of books for selected date range (I have two calender objects for that) for the respective monthyear and type.

It is working fine, but what I need to display is percentage of each type of books for respective months.

For e.g. in Jan 2010; there are total 500 books, out of which 100 are of type A, 200 each of type B and C.

I want to display for Jan 2010, for type A, 20%, for type B and C 40% each. This should vary as per the count of books for other months.

I am not getting how to achive it. Could you please help me out? Thanks in advance.

My expression is

=count({<Date = {">=$(vFromDate) <=$(vToDate)"}>} BookID)

(As I am having personnel edition of qlikview; I will not be able to open any external .qvw file)

Calculating percentage value in a chart

jagannalla — Fri, 10 Feb 2012 10:32:28 GMT

=count({<Date = {">=$(vFromDate) <=$(vToDate)"}>} BookID) / count({<Date = {">=$(vFromDate) <=$(vToDate)"}>} Total BookID)

Check Show in Percent(%) in number tab for the exp

Calculating percentage value in a chart

CELAMBARASAN — Fri, 10 Feb 2012 10:38:07 GMT

Hi,

If you have a field in the name month year then,

Try with this expression,

=Count(Books)/Count(Total <MonthYear> Books)

Check the in percentage option in the number tab of the chart properties.

Hope it helps

Celambarasan

Calculating percentage value in a chart

jagan — Sat, 11 Feb 2012 07:46:10 GMT

Hi,

Try the following expession

=Count({<Date = {">=$(vFromDate) <=$(vToDate)"}>} BookID) /

Count({<Date = {">=$(vFromDate) <=$(vToDate)"}>} Total <MonthYear> Books)

Regards,

Jagan

Calculating percentage value in a chart

Mon, 13 Feb 2012 05:20:18 GMT

Hi,

This expression gives me wrong results. I have 36 books of type 'A' and 23 books of type 'B' in the month of Jan 2010. So th total books = 59. So my requirement is that while showing percentage for Jan 2010, it should be based on 59. i.e.type 'A' books = 61.01% and 38.93%. But after implementing the solution given by you, it is giving results as type 'A' books = 27% and type 'B' books = 17% which is wrong.

Re: Calculating percentage value in a chart

Mon, 13 Feb 2012 05:22:04 GMT

Hi,

This expression gives me wrong results. I calculated a field in script as MonthYear = monthname(Date). I have 36 books of type 'A' and 23 books of type 'B' in the month of Jan 2010. So th total books = 59. So my requirement is that while showing percentage for Jan 2010, it should be based on 59. i.e.type 'A' books = 61.01% and 38.93%. But after implementing the solution given by you, it is giving results as type 'A' books = 2% and type 'B' books = 1% which is wrong.

Re: Calculating percentage value in a chart

Mon, 13 Feb 2012 05:23:03 GMT

Hi,

Calculating percentage value in a chart

jagan — Mon, 13 Feb 2012 05:28:00 GMT

Hi,

Can you attach the Qlikview file. It would be useful to solve.

Regards,

Jagan.

Re: Calculating percentage value in a chart

jagan — Mon, 13 Feb 2012 08:05:53 GMT

Hi,

Please check the attached file for solution.

Hope this helps you.

Regards,

Jagan.

Re: Calculating percentage value in a chart

Mon, 13 Feb 2012 13:50:40 GMT

Hi,

I cant attach qlikview file. Also I can't open your file as I have

personnel edition of qlikview.

On Mon, Feb 13, 2012 at 1:35 PM, jagan mohan <

Re: Calculating percentage value in a chart

CELAMBARASAN — Mon, 13 Feb 2012 14:05:09 GMT

Hi,

Can you able to attach sample data and image of the chart that shows wrong %?

Celambarasan

Calculating percentage value in a chart

jagan — Mon, 13 Feb 2012 14:14:04 GMT

Hi,

The content in the attached file is

Load Script:

LOAD * INLINE [

MonthYear, BookID, Count

Jan 2010, A, 45

Jan 2010, B, 56

Jan 2010, C, 54

Feb 2010, A, 21

Feb 2010, B, 42

Feb 2010, C, 32

];

In Straight table

I used MonthYear and BookID as dimensions.

Expression : =Sum(Count)/Sum(Total<MonthYear>Count)

Hope this helps you.

Regards,

Jagan.

Calculating percentage value in a chart

Mon, 13 Feb 2012 14:39:50 GMT

Hello

Not sure I understand, but what would I do (TOTAL-A) / A and (TOTAL-B) / B and percentage checkbox

I hope that helps

Re: Calculating percentage value in a chart

Tue, 14 Feb 2012 04:10:58 GMT

Hey, my problem got solved. I used divisor as Total BookId.

Thanks all for your help.

2012/2/13 Gabriel Vázquez <qliktech@sgaur.hosted.jivesoftware.com>

**
QlikCommunity <http://community.qlik.com/index.jspa>
Re: Calculating percentage value in a chart
created by Gabriel Vázquez<http://community.qlik.com/people/gabriel.vazquez>in
New to QlikView - View the full discussion<http://community.qlik.com/message/191041#191041>