Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator II

Month and Quarter sorting in excel

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

13 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
raju_salmon
Creator II
Creator II
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
raju_salmon
Creator II
Creator II
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
raju_salmon
Creator II
Creator II
Author

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
Creator III
Creator III

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
Creator II
Creator II
Author

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.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful