topic Grid chart (bubble graph) in QlikView

Grid chart (bubble graph)

Thu, 07 May 2015 11:05:02 GMT

Hi,

I want a Grid chart with three expressions; Number of breakdowns, hours of maintenance on breakdown and total costs of the breakdown .

How do i get this? i tried alot of things but it keeps says error in calculation. (the photo is made in access)

Thanks in advance.

Gysbert_Wassenaar — Thu, 07 May 2015 11:18:11 GMT

Use a scatter chart and add one dimension and your three expressions.

Thu, 07 May 2015 11:41:18 GMT

Ok, now i got 75% of it working.

But the number of breakdowns comes from the selected maintenance type.

Now it shows all maintenance type (=Count(Maintenance_type)) but it should only count maintenancetype Breakdown.

Gysbert_Wassenaar — Thu, 07 May 2015 11:54:00 GMT

Try changing that expression to =Count({<Maintenance_type={'Breakdown'}>}Maintenance_type)

Thu, 07 May 2015 11:58:14 GMT

Did it but all the parts that had 0 breakdowns are still in it.