topic Re: How to sort Calculated Dimension. in QlikView

How to sort Calculated Dimension.

Thu, 20 Nov 2014 10:33:28 GMT

Hi,

I have a calculated dimension: month(book_gl_date)&'-'& year(book_gl_date)

Here book_gl_date is a date type column. The result of above calulated dimension is a string in format like Nov-2014, Oct-2014...so on.

How to sort that in 'Sort' tab. By default it sorts by treating it as a text. Hence Apr-2014 comes before Jan-2014. I want to sort it as per calendar for example: Jan-2014, Feb-2014, Mar-2014...

Please find the attached screenshot.

Re: How to sort Calculated Dimension.

CELAMBARASAN — Thu, 20 Nov 2014 10:35:49 GMT

Better create this field in Script by using Date Functions

or change your calculated dimension to

Date(MonthStart(book_gl_date), 'MMM-YYYY')

and sort order as numberic

Re: How to sort Calculated Dimension.

anbu1984 — Thu, 20 Nov 2014 10:36:44 GMT

Use this expression in sort tab

=date(book_gl_date,'YYYYMM')

Re: How to sort Calculated Dimension.

ashfaq_haseeb — Thu, 20 Nov 2014 10:37:59 GMT

Hi,

Try this in script

MonthName(book_gl_date) as MonthYear

Now use this field as dimension.

Let me know if that worked.

Regards

ASHFAQ