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

Values not combining on joined tables

Hi everyone,

I am experiencing an issue where I have created a table chart and even though my campaign_name dimension value shares the same name, it is not being grouped together. Below is an example of what it looks like:

jokar_2-1642059606182.png

I have tables joined together through a date and a dimension called 'campaign_name'. In one of the tables - lets call it table1 - I created a field called 'campaign type' which is based on an ifnull expression based on a field which i'll call 'specialid'. 

The table that I have joined it too - lets call it table2 - does not have 'specialid' in it which is why I think the 'campaign_name' value is separated in the table whenever there are no values in a measure from the table1 source.

Can someone please let me know how I can combine these together as it should only be showing as one campaign? Would I need to map special_id somehow onto the table2 source?

 

Labels (3)
0 Replies