topic Problem with Month - Year Field in QlikView

Problem with Month - Year Field

Wed, 26 Jan 2011 16:36:38 GMT

Hi,

I need help with this. Im new to qiliview.

I have all a table with all the sales order in 3 years, with the date YYYY-MM-DD of the order.

I want to make a line chart that shows the sum(Sales) by month. So i made a field called Month Year, like this : month(saledate)&' '&year(saledate).

Everything oK... but when i want to sort it to show it in the chart the sort doesent work correctly.

I try to put expressiones, sort in load order, and nothing.

The sort i get is something like this.. : dic 2007 - jun 2007 - mar 2008 ... etc...

I try order by expression Year(..) & month(...) but nothing.

Alwayes there is a month-year that is not correctly order....

What can i dot??

Thanks!!!!!!!1

hector — Wed, 26 Jan 2011 16:42:47 GMT

Hi, instead of that create the calculated expression

date(saledate,'MM-YYYY')

and sort by numeric value

use dual

dual(month(saledate) & '-' year(saledate), year(saledate)*100 + month(saledate))

so the text will be 'Jan-2011', but the internal value will be 201101, and use numeric value for the sort

Rgds

Wed, 26 Jan 2011 16:48:00 GMT

hi,

Use the monthname function to craete the MonthYear field:

Monthname(saledate) as MonthYear

then you just have to order your MonthYear field by Numeric Value

hope this helps

Wed, 26 Jan 2011 18:49:19 GMT

Thanks!!! Problem solved!