chart

Thu, 12 Dec 2013 09:31:07 GMT

Hi All,

I have a bar chart where I'm taking date in the format 'MMM YYYY' as dimension and sum of revenue as expression.

The problem I'm facing is, dates are like 1/12/2013, 15/12/2013 here it should club both 1st and 15th date and give single bar with Dec 2013. But instead it is giving 2 bars both having Dec 2013.

how do I solve this?

Thanks

Re: chart

jonathandienst — Thu, 12 Dec 2013 09:46:43 GMT

Make sure that you are not using the Date() function alone to get the dates in MMM YYYY format. Date() changes the format only, the underlying date is unchanged. That's why you are getting separate columns for the dates in Dec 2013.

To get the chart to work, use this logic in a calculated dimension* - assuming the date dimension field is called TrDate:

=Date(MonthStart(TrDate), 'MMM YYYY')

(Change TrDate to the correct name of the date dimension)

HTH

Jonathan

* you could also do this in the load script to create a DateMMMYYYY field that you could use as a dimension

topic Re: chart in QlikView

chart

Re: chart