Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

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

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!

 

Labels (3)
14 Replies
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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

I have updated the app for your reference

sunny_talwar

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

image.png

 

LP27
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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

graph.PNG

 

 

 

 

 

Its not showing line in graph.

LP27
Creator II
Creator II
Author

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