Changing Date format for two field and combine them to single field in Qlik Sense

[LP27]

Hi Team,

Kindly refer the attached application below.

I have two tables belows-

Prod - Has Date field as (Month Year) in 'MMM YYYY' Format

Billing - Has date field as (Cal. year / month) in 'YYYY/MM' Format

I need to combine these two field into single date field and maintain same format as 'MMM-YYYY'

I have tried few ways and still it has not fixed. Can someone guide me out!

Thanks in advance!

[sunny_talwar]

Try this

Table2:
LOAD "Design Parent",
     Region,
     Year(Date#(MonthYear, 'MMM YYYY')) as Year,
     Date(MonthStart(Date#(MonthYear,'MMM YYYY')),'MMM-YYYY') as MonthYear,
   	 Production
Resident Prod;

and this

Billing:
LOAD
    "Global PMgr",
    Name,
    "Prod Family",
    "End Customer CCC(MD)" as "Design Parent",
    "Sales organization",
    Sales_Region,
     date(MonthStart(date#("Cal. year / month",'YYYY/MM')), 'MMM-YYYY') as MonthYear,
    "Net Billings in Doc Currency USD",
     ApplyMap('Map',"Sales organization",'N/A') as  Region
FROM [lib://xyz.xlsx]
(ooxml, embedded labels, table is Table)
Where match ("End Customer CCC(MD)" ,'Ford','Ford Industrial');

[LP27]

Thanks Sunny, I tried but the graphs are showing  invalid date format.

[sunny_talwar]

Can you show an image of what you are seeing in the graph?

[LP27]

I have updated the app for your reference

[sunny_talwar]

What have you updated? I see the same code in the script.. for example

[LP27]

Apologies! Kindly Check now Please.

[sunny_talwar]

Which graph is showing invalid dimension? All charts look okay to me, but I might be missing something

[LP27]

If you look at the graph this is not showing valid  dimension and measures.

Its not showing line in graph.

[LP27]

The Dates are repeating twice tooo ...if you check the graph