Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different table report

!

Hi,

My requirement is to prepare this table.

Problem.PNG

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)?

4 Replies
sunny_talwar

Are you looking to get all the 5 columns? or are you interested in getting the MTBF Value?

Not applicable
Author

Hi Sunny,

I need all the 5 columns in my table.

sujeetsingh
Master III
Master III

I have never scene the merged cells in Qlikview

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand