Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Row as % of total Value

I try to create a formula to show each row as % of the total value i.e. 45%, could you help please?

thanks

   

typeValueas% of total stock
AA£1,979,30845%
BB£1,214,06428%
CC£433,02810%
DD£386,5129%
EE£368,5968%
£4,381,508
Tags (1)
3 Replies
trdandamudi
Honored Contributor

Re: Row as % of total Value

May be like this:

Expression:

=Sum(Value) / Sum(Total Value)

awhitfield
Esteemed Contributor

Re: Row as % of total Value

Hi Maria,

see he attached worked example

Not applicable

Re: Row as % of total Value

=sum(Value)/sum({1}Total Value)

Community Browser