Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Expected Output?
for now, i need query for table like this
Supplier | Month | sum(amount january 2018 to january 2019) |
thanks
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: