topic Re: Sorting straight table at the bottom in QlikView

Sorting straight table at the bottom

Smeenakshi23 — Fri, 12 Jan 2018 04:57:38 GMT

Hello,

I have a straight table, The column in straight table be like , Product no, Date ,etcc.. For some product number the date values will be blank, i want to display those blank values at the bottom of my table..

For example i need to display as below

Product No Date

123 1/12/2018

123 1/13/2018

123 (blank)

546 1/12/2018

546 1/13/2018

546 (blank)

Re: Sorting straight table at the bottom

jonathandienst — Fri, 12 Jan 2018 05:04:08 GMT

Sort the table by Date - the nulls will go to the botttom.

Re: Sorting straight table at the bottom

Anil_Babu_Samineni — Fri, 12 Jan 2018 05:08:22 GMT

May be use this, If you are using 12 or more versions for Sort option by Expression?

Aggr(Only(TOTAL <[Product No]> Date), (Date, (FREQUENCY,DESCENDING)))

Re: Sorting straight table at the bottom

Smeenakshi23 — Fri, 12 Jan 2018 05:23:43 GMT

Could you please how to help the above script for below scenario.

Re: Sorting straight table at the bottom

Anil_Babu_Samineni — Fri, 12 Jan 2018 05:28:07 GMT

To this, I don't think you need complex one. But, To answer your question Can you play around

TYPE --> Disable Y-Axis and all

Product No --> Just, Use Descending Order and Use measure for sort option the same what you showed condition and move to descending order.

Re: Sorting straight table at the bottom

Smeenakshi23 — Fri, 12 Jan 2018 05:43:51 GMT

Thank you 🙂

Acutally, Type is field and i am not using it in table, i forget to mention that.. but what I did is , I added Type to the table, Sorted that to a descending order and hide the column.