Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Pivot table - Null values

Hi,

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
vishsaggi
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’)

PrashantSangle

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

Regards,

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

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