topic Re: Sort Chart not working in QlikView

Sort Chart not working

ivandrago — Thu, 29 Oct 2015 20:27:04 GMT

Hi,

I have the attached Document, I have a issue with the Sortkey not putting the correct numbers, I want it to be like the below

DateMonth, SortKey

01-JUN-2015, 1

01-JUL-2015, 2

01-AUG-2015, 3

01-SEP-2015, 4

01-OCT-2015, 5

01-NOV-2015, 6

Also what format does the SortKey need to be for it to work in the Expression? .

Thanks

MK_QSL — Thu, 29 Oct 2015 20:45:39 GMT

You can sort it without the additional table.. i.e. sort key. Check enclosed file..

maxgro — Thu, 29 Oct 2015 21:09:23 GMT

Fact:

LOAD ID, Date(Date#(DateMonth, 'DD-MMM-YYYY'), 'DD-MMM-YYYY') as DateMonth, Amount, Manufacturer, Type, Ver, Pick

INLINE [

ID, DateMonth, Amount, Manufacturer, Type, Ver, Pick

1, 01-JUN-2015, 500, B, OFF, LIVE, JS,

.......................

18, 01-NOV-2015, 300, B, ON, LIVE, JT

];

Concatenate

LOAD ID, Date(Date#(DateMonth, 'DD-MMM-YYYY'), 'DD-MMM-YYYY') as DateMonth, Amount, Manufacturer, Type, Ver, Pick INLINE [

ID, DateMonth, Amount, Manufacturer, Type, Ver, Pick

1, 01-JUN-2015, 500, B, OFF, ARCHIVE, JS,

..................

18, 01-NOV-2015, 300, B, ON, ARCHIVE, JT

];