Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight Table Object Sorted by Dimension

Hi,

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

Capture.JPG

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?

Capture1.JPG

 

1 Solution

Accepted Solutions
brijesh1991
Partner
Partner

Ronnie,

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

View solution in original post

3 Replies
brijesh1991
Partner
Partner

Ronnie,

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

View solution in original post

Not applicable
Author

Hi Brijesh, works perfectly now! Thank you sir.

Not applicable
Author

It worked for me as well

Thanks Brijesh