This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
Just Promote the DATE field on top in Sorting tab and then apply sorting as per your requirement.
View solution in original post
Hi Brijesh, works perfectly now! Thank you sir.
It worked for me as well