Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax set analysis - IF statement

Hi.

I am currently putting together a R12 statement; the statement without the IF condition is working 100% however when i add the IF condition in a set analysis string it does not work.

Your help is greatly appreciated in this matter.

Original IF statement = sum(If(vr_ktonr_RR<4000,vr_Netto_RR,0))

rolling 12 syntax = sum({1<OrderDate={">=$(=addmonths(monthend(max(OrderDate))+1,-12)) <=$(=max(OrderDate))"}>}Vr_Netto_RR)

1 Reply
fdelacal
Specialist
Specialist

can you add a qvw. example?