I do have the following problem in QlikView. I need to create the following chart:
Month: Jan2013 Feb2013 Mar2013 Apr2013 May2013 ....
KPI 1= Number of decisions in month x 46 76 40 23 81
KPI 2= Number of payments in month x+2 25 60 33 67 24
Dataset:
FileStatus
----------------
Status Date FileID
¨¨¨¨¨¨¨¨¨¨ ¨¨¨¨¨¨¨¨ ¨¨¨¨¨¨¨¨¨¨
Decision Jan2013 1
Payment Mar2013 1
Decision Jan2013 2
Payment Apr2013 2
So the payment of Mar2013 must be shown under Jan2013 and the payment of Apr2013 must be shown under Feb2013
Anyone any suggestion how to solve this?