topic Re: Calculate difference of amounts of two dates in App Development

Calculate difference of amounts of two dates

jw22 — Fri, 22 Mar 2024 07:51:37 GMT

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!

Re: Calculate difference of amounts of two dates

LRuCelver — Fri, 22 Mar 2024 08:17:18 GMT

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)

Re: Calculate difference of amounts of two dates

Clement15 — Fri, 22 Mar 2024 08:19:20 GMT

Hello, you can use alternate state for this.

Alternate States | QlikView Help

Re: Calculate difference of amounts of two dates

jw22 — Fri, 22 Mar 2024 11:33:28 GMT

Thank you very much, all solutions are working fine!