Set Analysis: I learned this the hard way

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

All

II discovered a glitch that may cause your results to be erroneous;

The expression :

Sum({<YR=,Qtr=,MO=,DA=,TranDate={">=$(=MonthStart(today(),-12)) <=$(=AddMonths(today(),-12))"}>} Sales)

Will return correct results for Month To Date of Last year.

However if you try to make it "look" nicer and easier to read and insert a CRLF (Carriage Return Line Feed) before the "<=" sign the results are completely different.

Sum({<YR=,Qtr=,MO=,DA=,TranDate={">=$(=MonthStart(today(),-12))

<=$(=AddMonths(today(),-12))"}>} Sales)

So Be careful!

Re: Set Analysis: I learned this the hard way

jerrysvensson — Wed, 16 Jan 2019 12:38:57 GMT

Can you supply an example?

topic Set Analysis: I learned this the hard way in QlikView

Set Analysis: I learned this the hard way

Re: Set Analysis: I learned this the hard way