Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

KPI Calculation

 

For the Average DSI calculation (formula below works fine in the KPI Box, but not when I  break it up over any dimensions)

 

sum(

 

   aggr(

 

Sum({<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, report_metric_key={'4'}>}days_supply_inventory)

 

 

    * (sum({<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, report_metric_key={'6'}>}forecast)/

 

 

    Sum(TOTAL {<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, report_metric_key={'6'}>}forecast)),

 

   

 

    Category,supplying_plant_code_desc, [Material Code]

 

)

 

)

 

3 Replies
Not applicable

Re: KPI Calculation

Average DSI After reaking into Dimension.pngAverage DSI.png

MVP
MVP

Re: KPI Calculation

Can you elaborate on which one is correct and which one isn't? May be provide a sample with expected output to help you quickly.

Not applicable

Re: KPI Calculation

Second one is correct Average should be 41.58. There are two dimensions Category and Plant Whse....without selecting any of the dimension KPI average is correct but when I select any of the two dimensions its incorrect.