topic Different table report in QlikView

Different table report

Thu, 14 Apr 2016 11:06:33 GMT

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

Re: Different table report

sunny_talwar — Thu, 14 Apr 2016 11:24:39 GMT

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

Re: Different table report

Thu, 14 Apr 2016 11:27:48 GMT

Hi Sunny,

I need all the 5 columns in my table.

Re: Different table report

sujeetsingh — Thu, 14 Apr 2016 11:28:24 GMT

I have never scene the merged cells in Qlikview

Re: Different table report

Gysbert_Wassenaar — Thu, 14 Apr 2016 12:01:13 GMT

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.