Mapping date column with Cross Table

[LP27]

Hi Everyone,

I am trying to mapping date fields in two tables, One table i am using cross tables for date field.

It produces duplicates after mapping the date field, not sure how to fix the issue.

Attached the Qlik sense app below for reference.

Thanks in advance,

[LP27]

Thanks for the info!

I will do it accordingly.

[LP27]

I used the same script as provided by you, MonthYear field is fixed, but now its not  showing Value and Rate field now.

Its not showing any field from date_2 table, except MonthYear.

check the image attached and check the update Qlik app.

[LP27]

I changed the table script.

now its not showing other column from Table_2.

[kaanerisen · Accepted solution]

Script that you shared is

Table2:
Load

[Rate],
date(MonthStart(date#(MonthYear,'MMM YYYY')),'MMM YYYY') as MonthYear,
Value
Resident date_2;
Drop tables Table2;

It should be

noconcatenate

Table2:
Load

[Rate],
date(MonthStart(date#(MonthYear,'MMM YYYY')),'MMM YYYY') as MonthYear,
Value
Resident date_2;
Drop tables date_2;

"Drop table Table2" should be "Drop table date_2" and add noconcatenate before table2 script to prevent autoconcatanation to date_2 table.

[LP27]

It worked! Thanks a lot!