7 Replies Latest reply: Jul 9, 2012 11:21 AM by jagan mohan rao appala

# Percentage in Pivot tables

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.

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

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

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

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,

Manohar

• ###### Re: Percentage in Pivot tables

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?

• ###### Re: Percentage in Pivot tables

Hi,

Can you come up with an examle?

Regards,

Jagan.

• ###### Re: Percentage in Pivot tables

Of course.

Here you are

Thank you.

• ###### Re: Percentage in Pivot tables

Hi,

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

Regards,

Jagan.