Data Sorting Problem in List Box and Line Chart.....

[sravan_v007]

Hi All,

Same problem again repeated in My another Dashboard...

how many ways we can sort data in QlikVIew..

This's my requirement...

Thanks in Advance.......

[tresesco]

Do you have any logic for this sorting? If not, then match is the best way which you don't want, then you can use IF.

[sravan_v007]

Hi tresesco,

Thanks for quick replay.

If I use MATCH, when ever next Quarter will add again I need to define it in match to sort.

which i don't want, So is there any other way of sorting

even I tried to use the formula in back end and try to sort it's not working even then also..

i.e

T1:

LOAD * INLINE [

    Q_Date, Amount

    Q12013, 300

    Q32012, 400

    Q42012, 500

];

load

  Q_Date,

  Left(Q_Date,2) & Right(Q_Date,2) as QuarterFilter

  Resident T1;

DROP Table T1;

is there anything else i can do here in script...

[Clever_Anjos]

You can use "Dual" function

load

  Q_Date,

  dual(Left(Q_Date,2) & Right(Q_Date,2),monthstart(Q_Date)) as QuarterFilter

  Resident T1;