Syntax set analysis - IF statement

Tue, 09 Apr 2013 11:53:21 GMT

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)

Re: Syntax set analysis - IF statement

fdelacal — Tue, 09 Apr 2013 13:07:47 GMT

can you add a qvw. example?

topic Syntax set analysis - IF statement in QlikView

Syntax set analysis - IF statement

Re: Syntax set analysis - IF statement