Qlikview Get Value where Condition

[Julez]

Hey,

I am new to Qlikview and I have a problem, which seems at first very easy to me, but I am really struggling with it.

I have a table with bank-transactions and transaction dates.

Now I want to sum up the value of the transaction for a specific date and return this sum.

Example:

If there are two transactions for 03/01/2020: 10000 USD and - 5000 USD,

I want to get 5000 USD as return.

How can I do this in Qlikview?

Greetings,
Julez

[Mark_Little]

HI @Julez 

The normal approach to this would be to have a date filter and then set up a chart with an Expression SUM(Value).

Value being the dimension holding your value. Selecting the above date in the Date filter would then return that value.

That is a straight forward approach, but there going to be different way to show what you want depending on the exact use case.