topic Re: Changing Date format for two field and combine them to single field in Qlik Sense in App Development

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

LP27 — Sat, 16 Nov 2024 04:54:53 GMT

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!

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

sunny_talwar — Tue, 20 Aug 2019 12:58:38 GMT

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');

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

LP27 — Tue, 20 Aug 2019 11:50:34 GMT

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

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

sunny_talwar — Tue, 20 Aug 2019 11:58:09 GMT

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

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

LP27 — Tue, 20 Aug 2019 11:59:29 GMT

I have updated the app for your reference

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

sunny_talwar — Tue, 20 Aug 2019 12:03:15 GMT

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

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

LP27 — Tue, 20 Aug 2019 12:07:32 GMT

Apologies! Kindly Check now Please.

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

sunny_talwar — Tue, 20 Aug 2019 12:22:34 GMT

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

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

LP27 — Tue, 20 Aug 2019 12:27:45 GMT

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

Its not showing line in graph.

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

LP27 — Tue, 20 Aug 2019 12:44:32 GMT

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

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

sunny_talwar — Tue, 20 Aug 2019 12:55:47 GMT

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

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

LP27 — Tue, 20 Aug 2019 13:21:02 GMT

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.

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

sunny_talwar — Tue, 20 Aug 2019 13:39:09 GMT

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?

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

LP27 — Tue, 20 Aug 2019 13:59:15 GMT

Below Graph is not working-

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

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

sunny_talwar — Tue, 20 Aug 2019 14:08:48 GMT

I think this is the issue

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