set analysis give strange output

[#1]

If I tried to change the if statement into set analysis is give  different output

Sum(if([Posting Date] >=FromDate and [Posting Date] <= ToDate,Opn_Pur_TXN))

output-538582

sum({<[Posting Date]={'>=$(=FromDate)'},[Posting Date]={'<=$(=ToDate)'}>}Opn_Pur_TXN)

output-1386261

but I remove

[Posting Date]={'<=$(=ToDate)'

this expression output of If statement is same as qlikview I.e. 538582

what's wrong??

[sunny_talwar · Accepted solution]

Try this instead and see if it matches the output from if or not

Sum({<[Posting Date]={">=$(=FromDate)<=$(=ToDate)"}>}Opn_Pur_TXN)

[PrashantSangle]

Hi,

Try below

sum({<[Posting Date]={">=$(FromDate)"},[Posting Date]={"<=$(ToDate)"}>}Opn_Pur_TXN)

Regards

[#4]

Maybe you should put if statement before sum statement.

Try this:

if([Posting Date] >=FromDate and [Posting Date] <= ToDate, Sum(Opn_Pur_TXN))

[#5]

when u remove [Posting Date]={'<=$(=ToDate)' it gives same output

possible reason can be todate would be the max(date) of the application.in this case result set will be correct.

If any other scenario give more details about dates

[awhitfield]

Hi Shweta,

try:

=Sum({< PostingDate = {'>=$(=FromDate)<=$(=ToDate)'} >} Opn_Pur_TXN)

HTH Andy

[#7]

thanks sunindia its helps

[sunny_talwar]

Awesome

Wasn't sure if it is going to give you the correct result or not, but I am glad it worked.

Sunny