Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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:
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,
Court
Correct the percentage formula or number presentation, sum(Sales) should not be shown as a percentage for example
Looks fine to me?
Look in to using the trellis option
Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.
Hello Adam,
Thank you for your quick reponse.
That with sales is a stupid mistake from me, I correct it and now it great
I will look in the Trellis Option. Never made a TrellisGrafic so it is a challenge for me, a learning-process
Court
Hi Court,
Not a problem, the trelis is useful but takes some fiddling to get right sometimes.
There is a good post here, albeit bar charts, which might help
Thanks