topic Re: How to SORT date in Straight Table? in QlikView

How to SORT date in Straight Table?

soha1902 — Fri, 06 Jun 2014 09:49:33 GMT

Hi All,

I am using one straight table like below. Date is my dimension.

Date	2014-June	2014-Feb	2013-Dec	2013-Oct	2013-Sep	2013-Aug	2010-Jan	2011-Dec	2009-Oct
Expression 1	3	2	2	3	5	3	1	2	4
Expression 2	1	2	7	3	2	1	0	9	8
Expression 3	2	4	5	2	1	7	4	2	1

Now I want to sort my Date Fields like following

Date	2014-Feb	2014-June	2013-Aug	2013-Sep	2013-Oct	2013-Dec	2011-Dec	2010-Jan	2009-Oct
Expression 1
Expression 2
Expression 3

I done the changes in sort tab. I selected Date field and under sort by box I selected numeric values = desending, but its not working.

Please help me regarding this. In my application its look like below image:

Re: How to SORT date in Straight Table?

MayilVahanan — Fri, 06 Jun 2014 09:53:34 GMT

Try like this

Chart properties -> sort -> expression (Ascending)

=MonthName(Date)

Re: How to SORT date in Straight Table?

Fri, 06 Jun 2014 09:55:02 GMT

Hi Soha,

sure it can't worm like this because you mix different sorting ways.

I understand you want Last year descending but months ascending

you have to build your own sort key for that in the script and sort the table on SortKey

best regards

Chris

Re: How to SORT date in Straight Table?

CELAMBARASAN — Fri, 06 Jun 2014 09:59:20 GMT

I don't think its a numeric/date field. It its so then it will get sorted.

Try with this as calculated dimension

Date(Date#(YourFieldName, 'YYYY-MMMM'), 'YYYY-MMMM')

For consistent solutions in all the places you should the change the way of creating this field in script itself.

Re: How to SORT date in Straight Table?

its_anandrjs — Fri, 06 Jun 2014 10:07:28 GMT

Hi Soha,

Are you sure there is single dimension it looks like 3 expression with different month names.

If it is single then in sort tab select sort by expression and write expression MonthName(DateField) and Descending

Re: How to SORT date in Straight Table?

soha1902 — Fri, 06 Jun 2014 10:13:17 GMT

Thanks for your reply. I tried to wrote expression MonthName(<MyDateFieldName>) but still its not sorting.

Please help...

Re: How to SORT date in Straight Table?

soha1902 — Fri, 06 Jun 2014 10:15:45 GMT

Actually from script date is coming in Date(<DateField>,'YYYY-MM') format.

But in chart I am convering in Date(<DateField>,'YYYY-MMM') format.

Re: How to SORT date in Straight Table?

soha1902 — Fri, 06 Jun 2014 10:33:33 GMT

Please help.

Re: How to SORT date in Straight Table?

MayilVahanan — Fri, 06 Jun 2014 10:53:27 GMT

Bring Number field like Num(Datefield) as DateFieldNum from your script and use DateFieldNum in the expression.

Hope that helps.

Otherwise provide the sample file.

Re: How to SORT date in Straight Table?

ajaygcet — Fri, 06 Jun 2014 11:03:09 GMT

Hi Soha ,

try Date(DateField,'YYYY-MM') in Sort by Expression.

or Convert it into Number like 'YYYYMM'