calculate amount in a year

[anya]

hii expert ,

i need help for my qlik sense, this is example from my data qlik sense.

from this table i need sum field amount of supplier from january 2018 to january 2019

Supplier	Date	Amount
A	01/01/2018	1500000
B	01/01/2018	2000000
C	01/01/2018	1000000
A	09/05/2018	1200000
B	10/05/2018	1000000
C	10/05/2018	1400000
A	13/10/2018	2100000
A	11/01/2019	1500000
B	12/01/2019	2000000
C	09/01/2019	1000000

thanks,

God Blessing

[prma7799]

Expected Output?

[anya]

for now, i need query for table like this

Supplier	Month	sum(amount january 2018  to january 2019)

thanks

[MindaugasBacius]

Try using set analysis:

= sum({<Date= {">=$(=Date(MakeDate(2018, 1, 1), 'DD/MM/YYYY')<$(=Date(MakeDate(2019, 1, 1), 'DD/MM/YYYY'))"}> } Amount)

You can find a lot of content about Set analysis:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/S...