Table

[#1]

Hi all,

I'm making a pivot table for my trucks in qlikview. Now I want it to show me only the trucks that have no data in it.

You got 3 types

- Trucks that got km's and the boardcomputer registered

- Trucks that got 0 km's in the boardcomputer

- Trucks that have no data. Now these trucks I want qlikview to show me but how can I accomplish this?

Already got this expression set up but it isn't giving me the right result:

If(isnull(sum(Production.TotalDistance)), 'Zero KM', 0)

All suggestions are welcome!

[MK_QSL]

Can you provide some sample data?

[Colin-Albert]

You cannot select nulls directly in QlikView.

This blog by  Henric Cronström shows how you can change nulls to another value that you can then select.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/02/finding-null

[its_anandrjs]

I assume this is the field which contains the details like Production.TotalDistance

Try like

If(isnull( Production.TotalDistance ) = -1, 'Zero KM', 0)