Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.

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