topic Re: Percentage in bar chart in QlikView

Percentage in bar chart

Tue, 15 Jul 2014 10:21:53 GMT

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'}))

Re: Percentage in bar chart

mdmukramali — Tue, 15 Jul 2014 10:26:57 GMT

Dear,

sum(sales)

(sum(Total <productname> sales)

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

Re: Percentage in bar chart

Gysbert_Wassenaar — Tue, 15 Jul 2014 10:27:07 GMT

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.

Re: Percentage in bar chart

its_anandrjs — Tue, 15 Jul 2014 10:29:04 GMT

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 ) )

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.

Re: Percentage in bar chart

Tue, 15 Jul 2014 10:36:55 GMT

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