Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Regarding % calculation

Dear All,

I want to calculate %Calculation like below ...

                                AFabulous              BPerformance                            CExcellent                                DVeryGood

Sum of salary               212000                    104000                                    57000                                        68000

% Calculation              100%             104000/212000*100=49.05%      57000/212000*100= 26.88%      68000/212000*100= 32.07%

Snapshot is also attached here for more clarity of understanding....

In 1st snapshot there is no expression added called %Calculation

%1.png

In Second snapshot the %Calculation expression showing wrong percentage. i want %Calculation to be shown in Total Mode only... not with Dimension's ..is it possible ,if yes then suggest me how i can achive the same with above calculation.

%2.png

my Qvw is also attached here for your reference.

Sarfaraz

5 Replies
Not applicable

Try this

=Sum(SALARY) /Sum(TOTAL {<Remarks={'AFaboulous'}>}SALARY)

fvelascog72
Partner - Specialist
Partner - Specialist

If I have understand correctly you can try Sum(SALARY) /Sum(TOTAL SALARY)

buzzy996
Master II
Master II

use this,

expression: =Sum(SALARY) / Sum({<Remarks={'AFaboulous'}>} Total SALARY)

Anonymous
Not applicable

check out the attached qvw for solution

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

The expression should be =Sum(SALARY) / Sum({<Remarks={'AFaboulous'}>} Total SALARY)

And the number format should be set to fixed/percent.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein