topic Re: Sorting issue in QlikView

Sorting issue

Fri, 05 Dec 2014 06:43:44 GMT

Hi All,

I have 10 dimensions in a straight table.I have sort on first priority dimension (which works). Next few i don't sort. There is a sort bottom down the priority (date based on Ascending). Will this work? It is Version 11.2

Sai.

Re: Sorting issue

sushil353 — Fri, 05 Dec 2014 06:46:09 GMT

Hi,

In sort tab you can promote or Demote your desired hierarchy of dimensions..

HTH

Sushil

Re: Sorting issue

rwunderlich — Fri, 05 Dec 2014 06:48:19 GMT

Yes, it should. Are you experiencing any specific difficulty?

-Rob

Re: Sorting issue

amit_saini — Fri, 05 Dec 2014 06:48:52 GMT

Sai,

I would suggest here to give condition while sorting, check if this will help you.

Thanks,
AS

Re: Sorting issue

Fri, 05 Dec 2014 07:00:09 GMT

It shows me the sorted order when I choose the dropdown. It does not show me in the table though.

Re: Sorting issue

sushil353 — Fri, 05 Dec 2014 07:08:58 GMT

In the Sort Tab>Sort by Expression..

Try this: Date(TakeOn)

or Date(Date#(Takeon,'DD-MMM-YYYY'))

HTH

Sushil