topic Re: AND statement help in QlikView

AND statement help

Anonymous — Thu, 30 Oct 2014 03:18:27 GMT

Hey I would like to something like, sum TransactionAmount thats between start and end dates, ( i would like to get the sum of transactions in a selected month )

if anyone could please point me in the right direction.

SUM( {< Year=, PeriodName=, postingDate={"<=$(vEndDate)" AND ">=$(vStartDate)"} >} TransactionAmount)

thanks.

Bon.

Re: AND statement help

danieloberbilli — Thu, 30 Oct 2014 03:38:11 GMT

try:

SUM( {< ... postingDate = {"<=$(vEndDate)" } * {">=$(vStartDate)"} >} ...

Re: AND statement help

jagan — Thu, 30 Oct 2014 06:03:45 GMT

Hi,

Try like this

SUM( {< Year=, PeriodName=, postingDate={">=$(vStartDate)<=$(vEndDate)" } >} TransactionAmount)

Note : postingDate, vStartDate and vEndDate should be in the same date format.

Regards,

Jagan.

Re: AND statement help

its_anandrjs — Thu, 30 Oct 2014 06:07:42 GMT

Try this way also

SUM( {< Year=, PeriodName=, postingDate={' >=$(vStartDate) <=$(vEndDate) ' } >} TransactionAmount )

SUM( {< Year=, PeriodName=, postingDate={" >=$(vStartDate)<=$(vEndDate) " } >} TransactionAmount )

Regards

Anand

Re: AND statement help

Thu, 30 Oct 2014 06:24:13 GMT

Hi,

Here no need to menstion AND

you can try this one

SUM( {< Year=, PeriodName=, postingDate={"<=$(vEndDate) >=$(vStartDate)"} >} TransactionAmount)

Re: AND statement help

Anonymous — Thu, 30 Oct 2014 20:03:07 GMT

Hey

Thanks for all your help, some worked some didn't, still it hasn't given me the results I was after,

maybe its something wrong with my codes. will go through everything again.

thanks.

Bon.

Re: AND statement help

fernando_tonial — Thu, 30 Oct 2014 23:56:41 GMT

Hi, check the field format postingDate and variable return in same format.

SUM( {$<Year=, PeriodName=, postingDate={">=$(vStartDate)<=$(vEndDate) " }>} TransactionAmount )

Best Regards.

Tonial.

Re: AND statement help

anbu1984 — Fri, 31 Oct 2014 01:36:52 GMT

Issue might be due to date format. If you can not figure out, can you post sample qvw

Re: AND statement help

Fri, 31 Oct 2014 03:08:50 GMT

Hi,

May be This works:

SUM( {< Year=, PeriodName=, postingDate = {" >=$(=vStartDate) <=$(=vEndDate) "}>} TransactionAmount )

Best,

Robert

Re: AND statement help

jagan — Fri, 31 Oct 2014 06:13:34 GMT

Hi,

Try like this

SUM( {< Year=, PeriodName=, postingDate={">=$(vStartDate)<=$(vEndDate)" } >} TransactionAmount)

Note : postingDate, vStartDate and vEndDate should be in the same date format.

Check date format of postingDate in list box and variables in vStartDate and vEndDate in text objects all should be in the same date format.

Hope this helps you.

Regards,

Jagan.

Re: AND statement help

Anonymous — Tue, 04 Nov 2014 21:34:57 GMT

I still haven't fixed this. I think all solutions provided is correct but currently im using the incorrectly data field. so I'll look further into which field is related.