topic Re: Variable date in sum in QlikView

Variable date in sum

RazRep — Thu, 11 Mar 2021 13:13:53 GMT

Hi,

I am trying to get the sum of amounts received on a certain day. Unfortunatly it seems like i'm not able to achive that.

I am already using the next formula to get the amount between two dates:

Sum ({<grtb_rek = {1100}, datum = {">=$(vDatumStart)<=$(vDatumEind)"}, debiteur -= {000000}, Dagboektype = {"Bank"}>} bedrag)

This works without problems, but when I change it to:

Sum ({<grtb_rek = {1100}, datum = {"=$(vDatumStart)"}, debiteur -= {000000}, Dagboektype = {"Bank"}>} bedrag)

it will return the amount of all dates which are loaded (like you have not set a date boundary). I have also tried using datum = {"8-3-2021"} and then it works fine. What am I doing wrong?

Re: Variable date in sum

eddie_wagt — Fri, 12 Mar 2021 13:09:37 GMT

Hello RazRep,

To solve it, the following is important to check.

1. What is your expression in variable vDatumStart?

2. What is the date format (dd-MM-yyyy) of the field datum and the date format in the variable

3. Syntax of your set analysis is wrong, but it depends on 1 and 2. This should be correct

Sum ({<grtb_rek = {1100}, datum = {"$(vDatumStart)"}, debiteur -= {000000}, Dagboektype = {"Bank"}>} bedrag)

Regards

Eddie

Re: Variable date in sum

RazRep — Fri, 12 Mar 2021 16:09:55 GMT

Hi Eddie,

The problem was indeed the date format. Now that I have changed that it works perfectly.

A big thanks to you!