Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
rlam1234
Contributor II
Contributor II

Only show one row in pivot table if dimension is null

I have a pivot table, showing the count of items where a dimension is null. I checked the "include null values" checkbox to show this.

In the screenshot below, you can see that I am getting the count, and since the dimension is null, a dash (-) is shown.

  1. How do I change the label to a value other than dash? I tried something like this:

    If(IsNull(my_value), 'is_null', my_value)

    This created a new row called "is_null", but it did not put the measure (count column) in that row. The count was still placed in the row with the dash.
  2. Since it is a pivot table with several fields, if the first field is null, all the subsequent fields are also null. I only want to show the first level as null, and turn off the ability to expand subsequent fields. Is it possible to do that?

 

2020-08-17_19-00-44.png

 

Any advice appreciated! Thanks.

2 Replies
Saravanan_Desingh

Did you check if it is a NULL string?

Len(my_value)=0 Or Len(Trim(my_value))=0 Or my_value=''
rlam1234
Contributor II
Contributor II
Author

@Saravanan_Desingh  Thank you for your reply. I was able to figure out the first part of my question.

I have an expression where if the dimension value is null, I put in "_Unknown", instead of showing the default dash character.

My second question is this is a pivot table with several fields. Valid values are blurred out below in the screenshot, but it is working as I want. Users can expand using the + icon to see other values.

If the dimension is null, I only want to show "_Unknown" once. Is there a way to turn off the + icons so that users can't expand? Each time they expand, it will always show the same thing, so only need to show it once.

2020-08-17_20-40-10.png