Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
nakuldev
Creator
Creator

Expressions should show the values in Straight table irrespective of any Nulls in Dimensions

Hi All,

In a straight table I will be having 20 Dimensions along with 15 expressions in which usually data will be populated as per the matching records. But as per my requirement if any of the dimensions have Null values and doesn't have any match with the expression, it should consider the existing dimensions and should display the value based on that.

For example I have Country with all the remaining dimensions as nulls but it should consider the country as base and should show avg(Value) based on that country or dimensions which are all available.

PFA attached sample. 

 

CountryRegionCityValueOutput
IndiaAPJDelhi1010
USAAMSNY2020
MalaysiaAPJKL3030
IndiaMumbai55
India15

Thanks in Advance

Nakul

1 Reply
olivierrobin
Specialist III
Specialist III

hello

why don't you use a crosstable, make a total at country level and so use avg()