Bar Chart

[#1]

I have a table like this and i have to make a bar chart to compare this time period.

Time Frame	Current Month Start Date	Current Month Last Date	Previous Month Start Date	Previous Month End Date
3 Months Vs 3 Months	12/1/2011	2/1/2012	9/1/2011	11/1/2011
6 Months Vs 6 Months	9/1/2011	2/1/2012	3/1/2011	8/1/2011
12 Months Vs 12 Months	3/1/2011	2/1/2012	3/1/2010	2/1/2011
Baseline Vs SPTD	1/1/2012	2/1/2012	4/1/2011	9/1/2011

The expression used will be "Current Month Last Date - Current Month Start Date" to get the bars. And current and previous months bars should be stacked.

I am using timeframe in dimension and "Current Month Last Date - Current Month Start Date" in expression for different timeframes but i am getting very weird values.

How can i do this ??

[IAMDV]

The problem is with the Date formats in your data. I mean if you simply copy this data to excel you can see that the dates are intrepeted incorrectly.

I mean if you see 2nd row (6 Months Vs 6 Months) - The Current Month Start Date is interpreted as 9th January 2011 instead of 1st September 2011. The month and dates are swapped and everything is interpreted as January 2011, Hence you since the difference between the dates is marginal. Same is the case with the other dates.

I hope this makes sense!

Cheers - DV

www.QlikShare.com