Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

sum with condition from another column

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

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

     then [Salary]

          else '' end)

6 Replies
omarbensalem
Esteemed Contributor

Re: sum with condition from another column

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

Not applicable

Re: sum with condition from another column

thank you

Re: sum with condition from another column

Try also for showing 0


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

Not applicable

Re: sum with condition from another column

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
Esteemed Contributor

Re: sum with condition from another column

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

Not applicable

Re: sum with condition from another column

Thank you very much !