Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to force null value into pivot table line

Hi,

I'd like to ask a little help.

I have a pivot chart like this one below:

ProductMeasureAMeasureB

A Product

23
B Product35
C Product46
Total9-

MeasureA and MeasureB are sum(<set analysis>Volume) expressions.

I have to show null value in MeasureB column for total.

Does somebody know a working solution for this? I tried with Product -= {''Total'} in set analysis but it shows zero value in the total cell, but I need null value.

Thank you

Gabor

10 Replies
sunny_talwar

Awesome

I am glad it worked.

Best,

Sunny