Discussion Board for collaboration on QlikView Scripting.
I want to create a bar chart that shows me the money collected per month, for this i have a table as follows:
The idea is sum the values where the ACTUAL field is not empty, because ACTUAL with a date means the money was collected, i used the following expression but is showing the sum incorrectly:
Sum(Aggr(If(len(ACTUAL)<> 0, Sum([MRC (USD)])+sum([OTC (USD)])),ACTUAL))
Anyone can help me?
You can create MonthActual field as dimension in Load Script and calculation like:
sum(aggr( RangeSum( sum([OTC (USD)]), sum([MRC (USD)])), ACTUAL))
or just simple:
RangeSum( sum([OTC (USD)]), sum([MRC (USD)])) and set up in QlikView properties:
I tried with your suggestion but is making the sum incorrectly.
May I ask you to put here sample data / .qvw with this issue?
Thanks for your answer Jacek.
For my problem both solutions are not working, because i take the Month dimension from another field, not from the ACTUAL.