Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mpnewbie
Partner - Contributor III
Partner - Contributor III

Concatenate tables in calculated dimension (chart function)

Hi,

I have the following tables:

Table1

IDStartDayEndDay
114
2915

 

Table2

IDStartDayEndDay
124
2712

 

I'm trying to create a distribution plot that compares day overlaps between the two tables, with the ID column for each serving as a calculated dimension so that a list of the dimension values would be 'Table1: 1', 'Table1: 2', 'Table2: 1', 'Table2: 2'. 

I am aware that it would be best practice to create the concatenated table in a load script, but I am using a vendor that only gives me access to chart functions, so how do I do this in a chart function?

1 Reply
naumanshah
Contributor III
Contributor III

Firstly, you'll need to have column names in both tables to be different from each other in order to differentiate Table1 and Table2 at chart level. After that you may create separate dimensions for both tables with something like following expression:

Overlap for Table1

=if(StartDay1>=StartDay2 and EndDay1<=EndDay2,ID1)

Overlap for Table2

=if(StartDay2>=StartDay1 and EndDay2<=EndDay1,ID2)

Hope it helps.