Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
agrimroquette
Not applicable

How to get common month name from two time stamps?

i have a excel sheet having two time stamps one is created date other is close date,

i want to calculate number of incidents open vs. closed in each month, problem is i cannot able to have a common month from two time stamp to show in a single bar chart.

please helpCapture1.PNGexample.PNG

1 Reply
sunny_talwar
Not applicable

Re: How to get common month name from two time stamps?

May be look into create a Canonical Date