Discussion Board for collaboration on QlikView Layout & Visualizations.
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!!!
Go to Solution.
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.
=Expression for achieve Number_of_active_users / total of Number_of_active_users
Hope it helps
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: firstname.lastname@example.org . Waiting for your response AEAP.
Thanks in advance.
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.
Can you come up with an examle?
Here you are
I think this is not possible as per my knowledge. But you can create another chart which displays percentages only.