topic Re: Straight Table Object Sorted by Dimension in QlikView

Straight Table Object Sorted by Dimension

Fri, 11 Jul 2014 05:53:12 GMT

Hi,

I have created a straight table that produces results as below image. D is derived frrom Dimension, and E derives from Expressions.

For the Dimension, DATE, it is a calculated dimension that combines month (in text format) and Fiscal Year (in numerical format) using expression [= [MONTH(MMM)]& " "& FY ]

Below is the sorting properties for DATE, I tried every options and the results are not sorting the months correctly, what can I do to resolve that?

Re: Straight Table Object Sorted by Dimension

brijesh1991 — Fri, 11 Jul 2014 05:59:38 GMT

Ronnie,

Just Promote the DATE field on top in Sorting tab and then apply sorting as per your requirement.

Re: Straight Table Object Sorted by Dimension

Fri, 11 Jul 2014 06:05:20 GMT

Hi Brijesh, works perfectly now! Thank you sir.

Re: Straight Table Object Sorted by Dimension

Mon, 04 Aug 2014 18:01:13 GMT

It worked for me as well

Thanks Brijesh