Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
i need to create a pivot-table like shown below. Every KPI is a formula and the columns "Last Year", "Actual Year" and "PLAN" describes the set expression. For example we will have a closer look on the KPI "Revenue"
Revenue = Sum(Sales)
Revenue Last Year = Sum({< Year = {'LY'}>} and so on.
How to implement? Any suggestions?
KPI | Last Year | Acutal Year | PLAN |
Revenue | |||
Order value | |||
On Time Delivery |
In order to get a response on posts like these, you generally need to submit some raw data so folks have something to work with, otherwise more than a little difficult trying to explain how to script things etc. One place you can look around for examples of things is the Design Blog area of the Community, that may provide some ideas on how to go about things to the point you can get a working QVW you can then attach to ask for help in solving any final issues...
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett