sum with condition from another column

[#1]

Hi, how can I input this query in Qlik??

sum( case when [Cut-off]=9/9/2017

     then [Salary]

          else '' end)

[OmarBenSalem]

sum({<Cut-Off={'9/9/2017'}>}Salary)

[#3]

thank you

[its_anandrjs]

Try also for showing 0

If(Cut-Off = '9/9/2017' , Salary, 0 )

[#5]

Hi,

is it possible to put a variabe instead of a date in the query ?

as in

sum({<Cut-Off={Date1}>}Salary)  where Date1 will be a date written by the user.

Thank you,

Marie

[OmarBenSalem]

sum({<Cut-Off={"$(Date1)"}>}Salary)

[#7]

Thank you very much !