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]

Did you reload your app after making the changes that I suggested?

[LP27]

Yes, I have now upload the app after reloading. 

I want to display MonthYear field in quarter. Few of the graphs are not displaying anything on chart but only two are displaying accordingly.

This graph is showing values-

Right Graph

This graph is not showing anything.

Thanks in advance.

[sunny_talwar]

I changed the dimension to MonthYear and it looks good, no?

If this is not what you want, then what do you want? Can you pinpoint the issue in the chart above?

[LP27]

Below Graph is not working- 

Measures are not working in these graph, other graph are fine.

[sunny_talwar]

I think this is the issue

Fix this ('MMM YYYY') and reload your app....