Percentage in bar chart

[#1]

hi All

I am trying to create a percentage chart   and was trying to use something like below. Its not working. Can anyone please help me in fixing this expression

sum(sales) /(sum(Total <productname> sales) + sum(Total <Productname , Sector ={'Marketing'}))

[mdmukramali]

Dear,

sum(sales)

/

(sum(Total <productname> sales)

+ sum(Total <Productname , Sector ={'Marketing'}) sales)

[Gysbert_Wassenaar]

Perhaps this:

sum(sales) /(sum(Total <productname> sales) + sum({<Sector ={'Marketing'}>}Total <productname> sales))

Make sure to use the exact case-senstive field names. Qlikview is case-sensitive with regards to field names.

[its_anandrjs]

sum(sales) 

/

(sum( Total <productname> sales) + sum(Total <Productname , Sector ={'Marketing'}   ?   ) )

I assume it is sales

sum(sales)

/

(sum( Total <productname> sales) + sum(Total  {< Productname=, Sector = {'Marketing'} >} sales   ) )

Or

sum(sales)

/

sum( Total { <productname=, Sector = {'Marketing'} >} sales

in Below expression in denominator where is the metrics you are forget to use any metrics there please check and let me know.

[#5]

Hi Sunny

Why don't you use productname as dimension and your formular would be like:

sum(sales)

you may use an additional formular:

sum({<Sector = {'Marketing'}>} sales)

Then in chart properties you check relative and your result will be a percentage...

Kind regards,

Anthony