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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sbkumar
Creator
Creator

problem in calculating simple percentage in QS

i am facing issue while calculating percentage.

original table

A       B     C     GRANDTOTAL(A+B+C)

1       2     3               6

2       4      2              5

3        1     2               6

NOw output table should be like this

A                   B          C          GT

16.6 %    33.3 %    50 %       100%     

lIKE THIS I NEED TO CALCULATE PERCENTAGE.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

LOAD

     A/(A+B+C) as A

     B/(A+B+C) as B

     C/(A+B+C) as C

     1 as [GRANDTOTAL(A+B+C)]

FROM ...


talk is cheap, supply exceeds demand