Calculate difference of amounts of two dates

[jw22]

Hello Qlik Community,

I have an table with following data:

And as filter panel I have "Date".

I now want a Measure where the difference between two Amounts of two Dates is calculated.

When 19.03.2024 and 20.03.2024 in the filter pane is selected, I want the measure to show -500. (1000-1500). Always the Amount of the older selected Date minus the newer selected Date.

Thank you!

[LRuCelver · Accepted solution]

Try this:

Sum({<Date={"$(=Min(Date))"}>} Amount) - Sum({<Date={"$(Max(Date))"}>} Amount)

If it doesn't work, try adding the date formatting:

Sum({<Date={"$(=Date(Min(Date), 'DD.MM.YYYY'))"}>} Amount) - Sum({<Date={"$(=Date(Max(Date), 'DD.MM.YYYY'))"}>} Amount)

[Clement15 · Accepted solution]

Hello, you can use alternate state for this.

Alternate States | QlikView Help

[jw22]

Thank you very much, all solutions are working fine!