topic Re: Percentage in Pivot tables in QlikView

Percentage in Pivot tables

Thu, 05 Jul 2012 15:25:13 GMT

Hi there, my first post in this community. I am quite new to qlikview and my question is very easy for the more experienced to answer.

I have a pivot table and i want to calculate the percentages of every column and every sub total compared to the General Total of the table.

I include jpegs of my data and the result that i want to achieve.

Thanks in advance for any answers.

Hope i become an expert in Qlikview to be able to help others who are new like i am now!!!

Re: Percentage in Pivot tables

MayilVahanan — Thu, 05 Jul 2012 15:33:48 GMT

Hi,

Try this,

=Expression for achieve Number_of_active_users / total of Number_of_active_users

For example

=Count(User)/Count(total User)

Hope it helps

Re: Percentage in Pivot tables

jagan — Fri, 06 Jul 2012 06:27:16 GMT

Hi,

Try this expression

=Count(Active_Users) / Count(TOTAL Active_Users)

Else if you are using Straight table then try using Relative option in Expression tab.

Hope this helps you.

Regards,

Jagan.

Re: Percentage in Pivot tables

Fri, 06 Jul 2012 07:26:07 GMT

Dear Experts,

I am new for QlikView, I'd like to request you to learn for each and evrything on QlikView, so request you send any study materials on it. My personal email id: deva.manu1@gmail.com . Waiting for your response AEAP.

Thanks in advance.

Thanks,

Manohar

Re: Percentage in Pivot tables

Sat, 07 Jul 2012 17:19:38 GMT

Thank you both for your quick replies. What you both proposed did the job perfectly!

Thank you both again!

Now for another question:

I know that there is an option in qlikview to show the totals above or below the table data.

How can i show, in a new column below the table data the same totals but in percentages?

Thank you in advance for any answers.

Re: Percentage in Pivot tables

jagan — Mon, 09 Jul 2012 10:20:25 GMT

Hi,

Can you come up with an examle?

Regards,

Jagan.

Re: Percentage in Pivot tables

Mon, 09 Jul 2012 10:27:13 GMT

Of course.

Here you are

Thank you.

Re: Percentage in Pivot tables

jagan — Mon, 09 Jul 2012 15:21:09 GMT

Hi,

I think this is not possible as per my knowledge. But you can create another chart which displays percentages only.

Regards,

Jagan.