Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

agrimroquette
Contributor II

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

6 Replies
ahaahaaha
Honored Contributor

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

You can an example of data?

agrimroquette
Contributor II

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

i want a single bar chart to show open Vs. Close month wise analysis

agrimroquette
Contributor II

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

i want common month name from "Creation Date" and "Accounted for" to show in one bar chart

agrimroquette
Contributor II

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

ahaahaaha  please help if you can

ahaahaaha
Honored Contributor

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

You use the Master-calendar?

See this link Generating Missing Data In QlikView

Regards,

Andrey

agrimroquette
Contributor II

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

no i didnt used master Chandler

Community Browser