topic Re: set analysis give strange output in QlikView

set analysis give strange output

Fri, 22 May 2015 09:37:29 GMT

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 — Fri, 22 May 2015 09:41:53 GMT

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

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

PrashantSangle — Fri, 22 May 2015 09:43:03 GMT

Hi,

Try below

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

Regards

Fri, 22 May 2015 09:43:49 GMT

Maybe you should put if statement before sum statement.

Try this:

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

Fri, 22 May 2015 09:45:32 GMT

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 — Fri, 22 May 2015 10:15:36 GMT

Hi Shweta,

try:

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

HTH Andy

Fri, 22 May 2015 11:44:02 GMT

thanks sunindia its helps

sunny_talwar — Fri, 22 May 2015 11:47:50 GMT

Awesome

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

Sunny