Sort order for columns in CSV

Newuser_qlik — Mon, 10 Jun 2024 10:11:31 GMT

Hi All,

I have the below columns. But when storing in CSV format in script, the order of columns are not correct. Can you let me know how to get the MMM-YY columns sorted and stored in CSV

ID	AMOUNT	DATE	Nov-23	23-Dec	23-Jan	23-Feb	23-Mar	23-Apr	23-May
3119	41,202.04	11/24/23	13	0	12	88	56	12	16.53
6040	46,454.56	01/20/24	0	0	45	45	463	11	512.43
22125	45,470.04	01/29/24	0	0	1000	233	232	96	-49.59
22691	45,470.04	01/29/24	0	0	200	244	56	100	525.21
70039	37,400.32	02/08/24	0	0	25	25	77	22	-33.88

Re: Sort order for columns in CSV

maxgro — Mon, 10 Jun 2024 15:36:39 GMT

for the order of columns try store column1, column2, ..... from ... into ....

STORE
[23-Jan], [23-Feb], [23-Mar], [23-Apr], [23-May],
[Nov-23], [23-Dec]
ID,
AMOUNT,
DATE
FROM ..... INTO .....;

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Store.htm

topic Re: Sort order for columns in CSV in App Development

Sort order for columns in CSV

Re: Sort order for columns in CSV