topic Re: Data Sorting Problem in List Box and Line Chart..... in QlikView

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

sravan_v007 — Tue, 10 Sep 2013 12:33:26 GMT

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.......

tresB — Tue, 10 Sep 2013 12:57:25 GMT

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 — Tue, 10 Sep 2013 14:17:57 GMT

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 — Tue, 10 Sep 2013 14:29:11 GMT

You can use "Dual" function

load

Q_Date,

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

Resident T1;