help on creating pivot table with formulas

[maxronny]

i am not able to create a pivot table in qlikview.

1) i have an excel file imported in qlikview:

DATE	PROJECTCODE	REVENUES	COSTS
31/12/2018	3078	1.000,00	900,00
31/12/2018	3126	1.100,00	990,00
31/12/2018	3149	1.210,00	1.089,00
31/12/2018	3169	1.452,00	1.306,80
30/06/2019	3078	1.597,20	1.437,48
30/06/2019	3126	2.395,80	2.156,22
30/06/2019	3149	2.635,38	2.371,84

2) in qlik view i wanna create these columns (red type) wih formulas but i am not able:

DATE	30/06/2019	30/06/2019	31/12/2018	31/12/2018		30/06/2019	31/12/2018	revenues 2019vs2018	costs 2019vs2018	profit/loss 2019vs2018
PROJECTCODE	Sum(REVENUES)	sum(COSTS)	Sum(REVENUES)	sum(COSTS)		profit/loss	profit/loss
3078	1597,2	1437,48	1000	900		159,72	100	597,2	537,48	59,72
3126	2395,8	2156,22	1100	990		239,58	110	1295,8	1166,22	129,58
3149	2635,38	2371,842	1210	1089		263,538	121	1425,38	1282,842	142,538
3169	0	0	1452	1306,8		0	145,2	-1452	-1306,8	-145,2

attached the qvw file

any suggestion? thank you in advance

[martinpohl]

see attached

Regards

[maxronny]

thank you very much for your reply.

can you tell me how can i get these other columns

revenues 2019vs2018	costs 2019vs2018	profit/loss 2019vs2018
597,2	537,48	59,72
1295,8	1166,22	129,58
1425,38	1282,842	142,538
-1452	-1306,8	-145,2

thank you very much for your support.

[maxronny · Accepted solution]

I found the solution.

DSUM in excel file can be written in qlik like this:

=Sum({<[DATE] = {'31/12/2018'}>} [REVENUES])