Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jakobjosef
Creator
Creator

if-Statement + Limitation at the same time

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

1 Solution

Accepted Solutions
olivierrobin
Specialist III
Specialist III

hello

what about

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

if ( status='planned', Sales)) 

?

View solution in original post

2 Replies
olivierrobin
Specialist III
Specialist III

hello

what about

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

if ( status='planned', Sales)) 

?

View solution in original post

jakobjosef
Creator
Creator
Author

perfect, works, thank you very much Olivier!