Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
!
Hi,
My requirement is to prepare this table.
The calculation for MTBF column is
MTBF = Sum(Hours)/(No.of months)
Example: MTBF for OHP1 - Crusher is (200+300+200+880+300)/5
MTBF for M1-InPit Crusher is (300+414)/2
Please help me in this regard. What can be the type of the table used? How it can be created?
Note: If this kind of table is not supported, please suggest the best possible solution(type of chart/table)?
Are you looking to get all the 5 columns? or are you interested in getting the MTBF Value?
Hi Sunny,
I need all the 5 columns in my table.
I have never scene the merged cells in Qlikview
Try sum(total <Equipment> Hours)/count(total <Equipment> distinct Month) as expression for MBTF Value. Replace Equipment, Hours and Month with the exact case sensitive field names of your document.
Note, merged cells are not possible. You could make the MBTF expression a calculated dimension so that it gets added to dimensions on the left side of the pivot table. You'd have to use =aggr(sum(Hours)/count(distinct Month),Equipment) as expression for the calculated dimension.