Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable

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')