topic Re: Sorting Null at last row in QlikView

Sorting Null at last row

Fri, 14 Nov 2014 08:04:14 GMT

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

Re: Sorting Null at last row

ashfaq_haseeb — Fri, 14 Nov 2014 08:06:12 GMT

Hi,

Attachment missing

Regards

ASHFAQ

Re: Sorting Null at last row

Fri, 14 Nov 2014 08:07:31 GMT

Example here~~~

Re: Sorting Null at last row

sujeetsingh — Fri, 14 Nov 2014 08:12:03 GMT

File not opened giving error

Re: Sorting Null at last row

ashfaq_haseeb — Fri, 14 Nov 2014 08:12:59 GMT

Document corrupted

Cannot open

Regards

ASHFAQ

Re: Sorting Null at last row

Fri, 14 Nov 2014 08:18:37 GMT

Upload done~

Re: Sorting Null at last row

sujeetsingh — Fri, 14 Nov 2014 08:35:34 GMT

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.

Re: Sorting Null at last row

Fri, 14 Nov 2014 08:44:19 GMT

could you give me example qvw file?