Discussion board where members can get started with Qlik Sense.
i have following structure
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?
Maybe rename your fields to common names?
Date_1 as Date,
RecCount1 as Reccount,
'Table1' as Table
Date_2 as Date,
RecCount2 as Reccount,
'Table2' as Table
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 this