topic Re: Using variables in a sum formula in QlikView

Using variables in a sum formula

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

I can not get this formula to work with a variable.

I want to replace the 6 with a variable (manually set month)

Can anyone help me?

Sum({<Month={'<=6'},Year={"$(=Year(Today()))"},[Dept. No]={'820'},Project={'SKAND-820*'}>} Hours)

I have made a variable "vMonth" (see below) but it does not work.

tresB — Thu, 10 Aug 2017 09:59:35 GMT

How did you try putting the variable in the expression? Like:

Sum({<Month={'<=$(vMonth)'},... ?

kaushiknsolanki — Thu, 10 Aug 2017 09:59:54 GMT

Try this,

Sum({<Month={'<=$(vMonth)'},Year={"$(=Year(Today()))"},[Dept. No]={'820'},Project={'SKAND-820*'}>} Hours)

Regards,

Kaushik Solanki

ankur_abhishek — Thu, 10 Aug 2017 10:08:03 GMT

Sum({<Month={'<=$(vMonth)'},Year={$(=Year(Today()))},[Dept. No]={'820'},Project={"SKAND-820*"}>} Hours)

fabricius — Thu, 10 Aug 2017 10:13:18 GMT

Thanks a LOT 😉

fabricius — Thu, 10 Aug 2017 11:59:06 GMT

Works 🙂 Thanks a lot for your help.