topic export in excel data in numerical format in QlikView

export in excel data in numerical format

Wed, 03 Nov 2010 13:24:20 GMT

hi,

i have a pivot table on qvw,

PROJECT	TASK	=Num(aggr(SUM(ACTUAL),TASK),'0,00')	TIME	2008	2009	2010
PROJECT2	TASK2	2,33		-	3	-
PROJECT2	TASK3	3,84		1	-	-
PROJECT2	TASK4	4,32		-	3	-
PROJECT2	TASK5	1,88		-	-	3

when i export this object on excel, column =Num(aggr(SUM(ACTUAL),TASK),'0,00') is not in numeric format in excel. i would like export this column in numeric format and keep comma.

export in excel data in numerical format

fernandotoledo — Wed, 03 Nov 2010 15:37:28 GMT

try '#.##0,00'

export in excel data in numerical format

Wed, 03 Nov 2010 16:05:20 GMT

hi Fernando,

with that i obtain:

PROJECT	TASK	=Num(aggr(SUM(ACTUAL),TASK),'#.##0,00')	TIME	2008	2009	2010
PROJECT2	TASK2	2.##0,00		-	3	-
PROJECT2	TASK3	4.##0,00		1	-	-
PROJECT2	TASK4	4.##0,00		-	3	-
PROJECT2	TASK5	2.##0,00		-	-	3

excel understant it is a numeric because . but result is not i want. What means '#.##0,00'?