Remove Empty rows from pivot table

[bhavyad]

NEw to qliksense, I am trying to build the hierarchy, I do not want the empty rows should be shown.

Could someone help me in this.

Note: tried unchecking include null values in the data handling as well as in the dimension

[Chanty4u]

If you have a pivot table that is showing blank fields (rows), use this formula to set those blanks to null:

 =IF(ISNULL(fieldname), NULL(), fieldname)

then uncheck the "Include null values" box.

[bhavyad]

 =IF(ISNULL(fieldname), NULL(), fieldname)

Above expression should be entered on every field?

I have like 10 rows ,on every row this should be done?

[Chanty4u]

yes whatever the dimension you have the nulls you can use similar.

can you attach any screenshot ?

[bhavyad]

Below find the below screnshot:

Last row will show the username.

I would like to get all these empty rows deleted for this ...

[BrunPierre]

Add this to your load script.

If(IsNull(Field) or Len(Field) = 0, Null, Field)) as Field;

Select suppress when a dimension's value is null

And now use it wherever you are calculating like this

Sum({$<Field-={'Null'}>} Field)

or

If(Field<>'Null', Sum(Field))

[bhavyad]

@Brun Above expression should be entered for every dimension I have and should I uncheck include zero values

[BrunPierre]

Have you tried this?

---

Add this to your load script.

If(IsNull(Field) or Len(Field) = 0, Null, Field)) as Field;

Select suppress when a dimension's value is null

And now use it wherever you are calculating like this

Sum({$<Field-={'Null'}>} Field)

or

If(Field<>'Null', Sum(Field))

[BrunPierre]

If(IsNull(Field) or Len(Field) = 0, Null, Field)) as Field;

Select suppress when a dimension's value is null

And now use it wherever you are calculating like this

Sum({$<Field-={'Null'}>} Field)

or

If(Field<>'Null', Sum(Field))

[bhavyad]

I am very new to qliksense...In Load script what exactly to be entered? and where to enter this:

Select suppress when a dimension's value is null

And now use it wherever you are calculating like this

Sum({$<Field-={'Null'}>} Field)

It will be great if you could explain this.

[BrunPierre]

Are you able to post the load script, expression and perhaps a snippet of the populated chart object.