topic Sorting problem in chart in QlikView

Sorting problem in chart

Sat, 05 May 2012 18:56:13 GMT

I have the following dimension in my chart

if(region_short_name='KAR',Gen_Date_Mn)

where Gen_Date_Mn is jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,dec

i want to show the chart in these way

Jun,Jul,Aug,Sep,Oct,Nov,Dec,Jan,Feb,Mar,Apr,May

swuehl — Sat, 05 May 2012 19:14:18 GMT

You can try a sort expression like

= match(Gen_Date_Mn,'Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May')

nilesh_gangurde — Sat, 05 May 2012 19:44:48 GMT

In the sort tab mark the expression and write the expression as given below :

if(wildmatch(Gen_Date_Mn,'Jun'),1,if(wildmatch(Gen_Date_Mn,'Jul',2,if(wildmatch(Gen_Date_Mn,'Aug'),3,if(wildmatch(Gen_Date_Mn,'Sep'),4)))))

and do the same for all the months.

I am sure that It will help you.

Regards,

Nilesh Gangurde