Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ankit28287
Contributor

Rolling 12 month Warranty cost per tractor

hi,

         want to create KPIs Month \ region\ dealer \ Product wise ​Warranty cost per Tractor               

        Warranty Cost per tractor for any month = (Last 12 month warranty cost payments)/(last 12 tractor sales)                 

         but we need to create KPIs for region\dealer\product wise as well keeping rolling month logic in mind

         is that possible to create rolling for 4 dimensions(month\region\dealer\product) and 2 measure(warranty cost\tractor Sales)?

         any suggestions to do it in optimize way to do in script so that application not become heavy)         

2 Replies
karthiksrqv
Contributor II

Re: Rolling 12 month Warranty cost per tractor

Hi Ankit,

Doing it for so many dimensions in the script could turn out to be very heavy.

Since, your need is for a 'KPI', this should work both from an acceptable-performance level and from maintainability perspective.

rangeavg(

count({<MonthNumber = {$(max(MonthNumber))}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),2)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),3)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),4)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),5)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),6)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),7)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),8)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),9)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),10)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),11)}>} [Warranty_Cost]),

count({<MonthNumber= {$(max(MonthNumber),12)}>} [Warranty_Cost]),

)

Similar expression for Sales.

ankit28287
Contributor

Re: Rolling 12 month Warranty cost per tractor

Thanks for reply, but I need to create month wise bar chart as

so in this Jan -17 bar will represent Avg Warranty Cost as -- last 12 month Cost / Last 12 Month Sales