Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mahesh_agrawal
Creator
Creator

Need to show Total Label in place of Null when expression returns zero

Hi Folks,

I have a Pivot Table in my attached QVW which shows count of sal for each name for the possible values of Country_Name field.

As per the requirement, the table should always show all values of name along with the Total at bottom.

When I select a Country_Name value for which "Sal" value is available, the table works fine. But, when a Country_Name value with no "Sal" is selected, the chart shows Null at the bottom of name column. It is understandable as we don't have any name for the selected Country_Name. But the user wants to see some label instead of the Null.

Please help. Thanks in advance.

Cheers,

Mahesh

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached example


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached example


talk is cheap, supply exceeds demand
lironbaram
Partner - Master III
Partner - Master III

hi

have a look at the attach example