Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Regarding Total

Dear All,


I want to calculate %Calculation like below ...


                                     Afabulous                           BPerformance                                       CExcellent                                         Sum of salary                 212000                                   104000                                                57000              

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

how i can achieve the same ...kindly suggest..

Sarfaraz

1 Reply
Not applicable

Hi Sarfaraz,

First declare one Variable

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

Then use following expression in %Claculation

=Sum(Aggr(Sum(SALARY), Remarks))/$(vFab)  *100

Regards,

Faisal