Month and Quarter sorting in excel

[raju_salmon]

Hi,

I have a straight table in which Quarter and Month are dimensions.

Month (Jan, Feb... Dec), Quarter (Jan-Mar 2016, Apr-Jun-2016...... Oct-Dec2017).

These 2 fields are properly sorting in straight table, however once i export into excel if i change sorting in excel (It goes only to A-Z or Z-A), is there anyway i can sort in excel same like Qlik straight table (like dual functionality)?

Thanks,

Raju

[Anil_Babu_Samineni]

Does Ctrl + Shft + L and then use "Sort smallest to largest" / "Sort largest to smallest"

[raju_salmon]

Thanks Anil for Reply, still it sort Apr, Aug, Dec...Sep (A-Z), but i need to sort like Jan,Feb...Dec.

[Anil_Babu_Samineni]

Not sure, How you are going to exporting? Can you give your process done

[raju_salmon]

Right click on the table box/Straight table and click on send to export. Once exported to excel, it does have Jan-Dec sorting only. And i did sort in excel A-Z then it goes Apr,Aug... Sep.... i want to sort it like Jan...Dec.

[Anil_Babu_Samineni]

Succeed !!! But, Not sure why you needed A-Z again. It's already been correct placed. Because, When ever we are exporting direct from View report it has to be same report where i believe. And test done, And it works as expected? Image please or better if you provide something to investigate

[raju_salmon]

I think i have not explained properly it seams. User can sort on any KPI (assume sales), then month order changes. Then if he wants sort based on month order, it is not possible in Excel. Then he has to sort in QV dashboard table then he has to export to excel.

Here the question was, is there any chance where user can sort month wise once he sort on any KPI which changes month order.

[alis2063]

In the Sorting tab,

You can write the Match function which will be return True values  as 1,

Sort by Expression

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

Regards,

Ali

[raju_salmon]

Thanks Ali, but it does not support in excel. Once we export to excel, it is out of Qlik capability. So the question is how excel support to sort in back?

[Anil_Babu_Samineni]

Does this question related Qlikview / Excel my dear friend ??

If it is Qlikview related i believe we will get as expected

If Excel, I think we need some more information - You need to understand how Excel works and how sort offers much better where i explained little earlier.