topic convert monthname issue in QlikView

convert monthname issue

amien — Mon, 13 Dec 2010 17:05:40 GMT

i have a barchart:

dimension : yearmonth (201001)

expression : sum(value).

how i want to change the values that the end users see in dimension --> jan-2010

therefor i use a different dimension (monthyear).. only problem is the sorting.

i have changed in the sorting tab into an expression sort : yearmonth.

this works on 1 machine but not on the other one .. and i dont know why.

or perhaps someone has a different solution?

convert monthname issue

Mon, 13 Dec 2010 17:20:39 GMT

Hi Amien

I'm not sure exactly how you want it, but you can convert the date to Qlikviews native Date-format like this:

Num(Date#(201001, 'YYYYMM')) = "40179"

And then work with the native date to get your Jan-2010 format.

Normal 0 false false false MicrosoftInternetExplorer4

Date(40179, 'MMM-YYYY') = "jan-2010"

convert monthname issue

mazacini — Mon, 13 Dec 2010 17:34:36 GMT

Hi Amien

Let me preface my remarks by pointing out that I am a newbie, but I thought I might pass on a solution I found in the forums to a similar problem I had.

I had a month field (PERIODCODE) in the same format as yours. I inserted an inline table early on in my script. PERIODCODE, YEAR, MONTHNO, and sorted in month order. My MONTHNO was an integer from 1 to 12. I assume you could replace with mmm-yy.

This would seem manageable as long as you are not dealing with too many years.

Joe

convert monthname issue

amien — Mon, 13 Dec 2010 19:50:20 GMT

Thanks