Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
azmeerrehan
Partner - Creator
Partner - Creator

Straight Table Null Issue

I am using Qlik Sense. I  have a Sales Order NO and Sum (Sales)  Expression.  When I list the Sales Order NO and Sales as a Dimension I can see all the values including the Nulls but as soon as I use Sum(Sales) . I get only rows with Values, it drops all the Null values, even though All value check box is checked.

Labels (1)
2 Replies
qliksus
Specialist II
Specialist II

Uncheck the Supress Zero values and try . Aggreation function will make the null value as 0

azmeerrehan
Partner - Creator
Partner - Creator
Author

Already unchecked, also I dont want to use AGGR