Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Null Field - How would you approach this?

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. 

ProductsYTD Q2 ForecastQ2 VarianceQ2 - 2020
-$25$25$112
Pizza$5,977,761($3,418,295)$14,212,791
Burgers$39,767,717($1,987,766)$99,103,956
Labels (2)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

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

 

View solution in original post

3 Replies
Highlighted
Specialist
Specialist

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

 

View solution in original post

Highlighted
Partner
Partner

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. 

Highlighted
Specialist III
Specialist III

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.