Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Pivot Presentation

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?

 

KPILast YearAcutal YearPLAN
Revenue   
Order value   
On Time Delivery   
Labels (1)
1 Reply
Highlighted
Digital Support
Digital Support

Re: Pivot Presentation

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.