Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.