Null Field - How would you approach this?

[win_anthony]

I am completely stumped on how to approach this scenario. I have a dimension (ex: Products) with values but there is a null field in the dimension that is messing everything up. My problem is that I can easily suppress the null field but that throws off my totals. The client doesn't want to keep the null field either. 

How would you approach this scenario? I'm so lost and just looking to the community. 

Products	YTD Q2 Forecast	Q2 Variance	Q2 - 2020
-	$25	$25	$112
Pizza	$5,977,761	($3,418,295)	$14,212,791
Burgers	$39,767,717	($1,987,766)	$99,103,956

[vamsee · Accepted solution]

Hi @win_anthony ,

You might want to see why in the first place you are getting that Null value, as obviously Null values wouldn't have forecast and revenues.

If your data is missing Product description but has some ID related to it, you might wanna populate with that. If not, try populating Null values at the script level.

NullasValue *;
Set NullValue ='NA';

Refer: https://community.qlik.com/t5/QlikView-Documents/NULL-handling-in-QlikView/ta-p/1484472/page/3

[win_anthony]

Thanks for the advice. Kinda knew that this was it but was stubborn to think that I can make a quick set analysis or something that would give me the output I was looking for. 

Addressing the data is still probably the best approach. 

[Saravanan_Desingh]

Suppressing the NULL in the dimension, but want the should be included in the Aggregation. In such scenario, you can use AGGR in the expression.