if-Statement + Limitation at the same time

[jakobjosef]

Hello dear Qlik-View Community,

I have a problem concerning an if-statement combined with date-limitations.

I want the sum of sales to be shown, but just from 01.10.2017, and just the sales of employees with the status'planned'.

For both limitations I have the (correct) script-syntax:

Sum( {1 < date = {'>=43009'} > }    Sales)      (FOR DATE-Restriction)

Sum ( if ( status='planned', Sales))                     (FOR STATUS-Restriction)

But both at the same time are not working. Do you know how i can combine them?

Thank you very much,

Jakob

[olivierrobin · Accepted solution]

hello

what about

Sum( {1 < date = {'>=43009'} > } 

if ( status='planned', Sales))

?

[jakobjosef]

perfect, works, thank you very much Olivier!