topic expression issue in QlikView

expression issue

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

Dear All, I have to write an expression for the following scenario:- I have to write a formula to get percentage for NC'S NC's/Total NC's * 100

lironbaram — Tue, 16 Jul 2019 05:50:37 GMT

have you tried :

(sum(NC) / sum(TOTAL NC))*100

petter — Tue, 16 Jul 2019 05:59:22 GMT

It should be something like this if the field is named NC:

Sum(NC) / Sum(TOTAL NC) * 100

The level that the total should be calculated at can be explicitly specified like this if needed:

Sum(TOTAL <USERID, ClusterName> NC)