Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Merge dimensions into 1

i have following structure

Capture.PNG

All have different Values,

records count also have different column name, so there isnt any association in data model,

I want To merge all the dates with common name Date and bring those associated records count in to the table/pivot Table,

How to acheive this in qlik sense?

2 Replies
Highlighted
MVP
MVP

Maybe rename your fields to common names?

edit:

Like

LOAD

     Date_1 as Date,

     RecCount1 as Reccount,

     'Table1' as Table

From TABLE1;

LOAD

     Date_2 as Date,

     RecCount2 as Reccount,

     'Table2' as Table

From TABLE2;

...

Highlighted
Creator
Creator

Record count is a calculated field here,and it differs for each of the 5 entity i have,

i want all the dates to  be merged into one common name date and values of record count accordingly, record count should be zero if the entity has no values,something like thisCapture.PNG