I want to make more PieCharts for one Dimension
I have two tables: Sales and Productgroups and I made two Dashboards, one for Sales and one for Products.
On the SalesDashboard I have a Straighttable, a BarChart and a PieChart. In all three the dimension is Company. The Expressions are: Sum(Sales), Sum(Targets), Sum(Sales) - Sum(Targets) and Sum(Sales) / Sum(Targets).
The presentation of KPI Sum(Sales) / Sum(Targets) is in %, the others in amounts.
On the ProductsDashboard I have a Pivottable, a BarChart and a PieChart. In the Pivottable the dimensions are ProductGroup and Product, in the BarChart and PieChart the dimension is a cycle – group with members ProductGroup and Product. The Expressions are: Sum(ProdSales), Sum(Costs), Sum(ProdSales) - Sum(Costs) and Sum(ProdSales) / Sum(Costs).
The presentation of KPI Sum(ProdSales) / Sum(Costs) is in %, the others in amounts.
Now I want to change my Dashboards, upgrade them so I have the next questions:
- ·On the SalesDashboard in the BarChart the presentation of the values are in large %-values, what is the reason of this and how can I change that in normal values.
- ·On the ProductDashboard in the PieChart the text productgroup is not complete : productgrou, what is the reason of this and how can I change that in normal values.
- ·On both Dashboards I wish to have more PieCharts: on the SalesDashboard a PieChart for every Company one PieChart and on the ProductDashboard a PieChart for every Productgroup one PieChart. Is this possible and how can I fix that.
In the future the data will come from QVD’s which are create in the DataWareHouse, so then the number of Companies is not four like now in my table at the moment, but n-companies. This also applies for ProductGroup and Product.
I can change the presentation of this Table, by putting a check mark by horizontal on the Presentationtab, then the CompanyNumbers become the ColumnNames and #Sales, etc. become the rows.
I will add my Qlikview Document PieCharts and a word document with my Grafics.
I hope that someone with more experience and knowledge in Designing can help me.
Thanks in regards,