Exclude null values in the measure in qlik sense pivot table

[dhruvain27]

I have one dimension and secondary dimension and one measure for a pivot table.

sum({<year={'2023'},sales={'total sales'}>}spend)/vDenominator

I'm using this measure for a pivot table.after exporting the data into excel getting null values.

i don't want to see the nulls even after exporting the data into excel.

In the dimensions we have the option check box to exclude or include but in the measure how?

HINT: if i place the <>0 in the expression we can achieve this , but i don't know  how to place in the expression.

[BrunPierre]

Hi, you uncheck the Show Null check-box to remove Null from the dimension.

[dhruvain27 · Accepted solution]

Thanks Brun.

I got the solution for this issue.

Answer: under the dimension properties we have the limitation there selected the exact value as >0.Then I exported the data into excel. There I'm not getting null vvalues.my issue resolved.

But thanks for reply brun.