Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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)
Thank you very much, all solutions are working fine!