Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'}))
Dear,
sum(sales)
/
(sum(Total <productname> sales)
+ sum(Total <Productname , Sector ={'Marketing'}) sales)
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.
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.
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