topic Re: Finding the sum in QlikView

Finding the sum

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

I am trying to get the result of

Sum(Processed_Dash * Ave_Cost_Dash)

When Date_Dash = today() & Status_Dash = 'WIP'

This is what I am trying

(Sum({$<Date_Dash={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))"}, Status_Dash={'WIP'}>} Processed_Dash))

(sum({$< Status_Dash={'WIP'}, Date_Dash={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00')-1,1,$(vHolidays)))"}>} Ave_Cost_Dash))

The correct result is 195,159

I am getting the result of 8,159,732

Re: Finding the sum

aarkay29 — Wed, 19 Jul 2017 01:19:29 GMT

Try This

(Sum({$<Date_Dash={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))"}, Status_Dash={'WIP'}>} Processed_Dash*Ave_Cost_Dash))

Re: Finding the sum

Kushal_Chawda — Wed, 19 Jul 2017 07:24:53 GMT

try this

Sum({$<Date_Dash={"$(=date(FirstWorkDate(ConvertToLocalTime(now(), 'GMT-05:00'),1,$(vHolidays))))"}, Status_Dash={'WIP'}>} Processed_Dash*Ave_Cost_Dash)