topic Re: if-Statement + Limitation at the same time in QlikView

if-Statement + Limitation at the same time

jakobjosef — Mon, 13 Aug 2018 07:53:27 GMT

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 — Mon, 13 Aug 2018 07:56:52 GMT

hello

what about

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

if ( status='planned', Sales))

jakobjosef — Mon, 13 Aug 2018 08:21:57 GMT

perfect, works, thank you very much Olivier!