Set analysis help

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

Hey guys,

I feel like I'm overthinking this one. I am just trying to grab data from June-December for this year. This is how I am attempting this, just tells me it contains only undefined values.

=(Sum({$<Status_Dash={'Completed'}, Month = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"},

MonthNum = {6, 7, 8, 9, 10, 11, 12},

Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>}

(Ave_Cost_Dash * Processed_Dash)))

(Sum({$<Status_Dash={'Completed'}, Month = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"},

MonthNum = {6, 7, 8, 9, 10, 11, 12},

Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>}

Emp_Act_Dash))

But if I do not include Month, or MonthNum, it works but collects different data. There is more Processed_Dash data then Emp_Act_Dash. I just want to have the same amount of data.

topic Set analysis help in QlikView

Set analysis help