Sorting Null at last row

[#1]

Hi , I have a straight table with a dimension and several Expressions. I did sort  By number desc ,Text A-->Z . It was working fine until Null Values dont come up. Null Value doesn't sort function. How can i show only Null Value at end(last row) still keeping my original sort for other dimension values A-->Z. I attach example qvw Please respond with example qvw file. Thanks in advance

[ashfaq_haseeb]

Hi,

Attachment missing

Regards

ASHFAQ

[#3]

Example here~~~

[sujeetsingh]

File not opened giving error

[ashfaq_haseeb]

Document corrupted

Cannot open

Regards

ASHFAQ

[#6]

Upload done~

[sujeetsingh]

You need to give a flag as

if(now(2) - Date(Date#(LAST_UPDATE_DATE_TIME, 'YYYYMMDDhhmmss'), 'YYYY-MM-DD hh:mm:ss')=null(),0,now(2) - Date(Date#(LAST_UPDATE_DATE_TIME, 'YYYYMMDDhhmmss'), 'YYYY-MM-DD hh:mm:ss'))

Now just Order it in the script as you want or use an expression to sort in your object.

[#8]

could you give me example qvw file?