topic Re: Line Graph per MM/YYYY in QlikView

Line Graph per MM/YYYY

Anonymous — Sun, 15 Jul 2012 13:13:44 GMT

Dear All,

I´m trying to create a line graph that shows a SUM pre month/year. The main problem is that I have different days in a base and the dimension "date([datefiled],'MM/YYYY')" is returning more than one register per month/year.

The expression is a simple SUM([value field])

Please let me know how I can solve it.

Thanks in advance.

Re: Line Graph per MM/YYYY

jonathandienst — Sun, 15 Jul 2012 15:22:42 GMT

The date() function does not remove the day value from datefield, it simply formats the display into (in your case) MM/YYYY format. To remove the day value and have only one dimension value per month, you can use:

Date(MonthStart(datefield), 'MM/YYYY')

Hope that helps

Jonathan

Re: Line Graph per MM/YYYY

Anonymous — Sun, 15 Jul 2012 19:05:22 GMT

Thanks Jonathan,

Working well !