topic Sorting in Chart in QlikView

Sorting in Chart

ashishpalkar — Tue, 08 Sep 2015 14:36:25 GMT

Hi There

I have below requirement ,

I have created line chart, the dimension data is coming as follows ,

MAR 2015

DEC 2014

AUG 2015

DEC 2015

JUN 2014

AUG 2014

JAN 2015

JAN2014 ... and so on.

I also have expression created as Sum(total)

In graph display I want to show above data in ascending order.

Thanks,

Anonymous — Tue, 08 Sep 2015 15:07:28 GMT

if your Dimension has a date Format you only Need to sort Dimension ascending (tab sort)

if your Dimension has a string Format you Need to transform it to a dateformat using

date#(stringdimension,'MMM YYYY') in tab sort "expression" and ascending

ashishpalkar — Tue, 08 Sep 2015 15:14:18 GMT

Thanks its working using date#(stringdimension,'MMM YYYY')