Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

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

New dimension based on if value is null or not

Hi All,

I am trying to create a new dimension which creates two groups: the first is campaigns that are a special campaign ID associated - it would be called 'Special campaign'; the second would be all campaigns without a special campaign ID associated - it would be called 'Not special campaign'.

This is an example of what the data looks like:

Campaign Special campaign ID
campaign 1 1234
campaign 2  
campaign 3  
campaign 4 1233
campaign 5 1111

 

Can someone help me what the best expression would be to do this?

Thank you in advance!

Labels (3)
1 Solution

Accepted Solutions
anat
Specialist II
Specialist II

If(is null(Special campaign ID), 'not special campaign', 'special campian') 

View solution in original post

2 Replies
anat
Specialist II
Specialist II

If(is null(Special campaign ID), 'not special campaign', 'special campian') 

jokar
Contributor II
Contributor II
Author

This worked - thank you!