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.
You can an example of data?
i want a single bar chart to show open Vs. Close month wise analysis
i want common month name from "Creation Date" and "Accounted for" to show in one bar chart
Andrey Khoronenko please help if you can
You use the Master-calendar?
See this link Generating Missing Data In QlikView
no i didnt used master Chandler
Retrieving data ...