This content has been marked as final. Show 4 replies
I have a field in my master calendar for MonthYear (MMM-YY)
I also have a field in there to Flag certain days (contains 1 or 0)
The MasterCalendar data holds a record for each day.
I want to produce another table which will sum all of the flags that contain 1 for each MonthYear.
I tried something like this:
But Qlikview gave me an error.
I would like it end up with a table as below:
Can anyone help with getting the right script for this?