I need to get the % of production based on the sum figures of 4 dimensions.
From the above table from the production figures i need to calculate the contribution of each city. How can I do it qlik chart.
(Sum(PRODUCTION) / Sum(TOTAL PRODUCTION))*1000
Actually the production is a variable
dimension is city
Production is $(vPremiumYTD)
How can i construct the statement.
Can you define your variable also vPremiumYTD
The Production is represented as vPremiumYTD
and the City is an dimension.
May be this?
(Sum($(vPremiumYTD)) / Sum(TOTAL $(vPremiumYTD)))*1000
the TOTAL you refer to any builtin QLIK field as there is no field by name TOTAL. The dimension field name is CITY
use help menu.
TOTAL is qualifier
Search for topics and videos - Qlik | Help
Let's consider this as example
Its working now. Thank you so much for your kind assistance.
Great, Please close this thread flag "Correct Answer"
Qlik Community Tip: Marking Replies as Correct or Helpful
Retrieving data ...