topic Re: Chart Sort of text (Date) in QlikView

Chart Sort of text (Date)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the below chart... and the sort on the Month is desc numeric. When I sort from ASC (which I want to show from Left to Right starting at 201611, 201612, 201701 (opposite of what you see below) I'm not getting 201611, 201612, 201701 which is want I need. I'm thinking it's because the dimension is a text value and not date. Anyway, how would I get my desired results. Attached is a sample of a chart.

Re: Chart Sort of text (Date)

sunny_talwar — Tue, 31 Jan 2017 14:40:28 GMT

Try this with ascending sort:

=If(NoOfRows() - RowNo() < 3, (Count({<[MBR_ACTIVE_AT_MONTH_END] = {"1"}>}MBR_ACTIVE_CLT_CLT_PGMID) ) )

Re: Chart Sort of text (Date)

buzzy996 — Tue, 31 Jan 2017 14:46:21 GMT

hi,can u try tis way..in ur load script along with data create a new field with numeric value

urdate,numericfield

201701,1

201612,2

201611,3

and load same as sequence above by using order by numerifield

HTH.