Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Pivot table - Null values


I have a pivot table where i'm displaying YTD amounts as the only expression and have multiple dimensions.

I'm having issues with NULL values in 'CURRENT MONTH ACTIVITY PROFILE' column where i'm asked to display the profile of a user.

As you see in the below screenshot, for Aug-18 User1 has 7count whereas User2 has 0count.

Requirement is User1 should have only value 'CASUAL' as his profile based on current month's count where as User2 should have INACTIVE (if null call it INACTIVE). When I replace NULL with INACTIVE User2 is assigned INACTIVE as expected but User1 has 2 profiles CASUAL and INACTIVE.

Can someone please help me to have only ONE profile per user based on current month counts? Thanks!

Screen Shot 2018-08-27 at 8.27.34 PM.png

3 Replies
Champion III
Champion III

‌mmay be this for your expr or calculated dimension

= If(Sum(aggr(sum(yourmeasurefield), dim1,dim2,dim3,iserid))>0, ‘Casual’, ‘Inactive’)


how you are calculating "Current Month Active Profile"???


Great dreamer's dreams never fulfilled, they are always transcended.
Contributor III
Contributor III

Profile is a pre-calculated field in the database which i'm pulling into Qlikview

Current Month Active Profile: If(DATE >= monthstart(max(DATE)) and DATE <= monthend(max(DATE)), PROFILE, 'INACTIVE')