topic Need help with Set Analysis Dynamic Date in QlikView

Need help with Set Analysis Dynamic Date

Fri, 26 Apr 2013 14:07:15 GMT

I have two basic date based set analysis summations. One works (bottom) the top one does not.

The dynamic date generates the same date 04/01/2013 when I place it in a text box for testing.

Not sure why it still sums up all months regardless. No errors, but wrong summation.

Dynamic still sums up all months;

=Sum({$<RevMonth={'=Date(MonthStart(Today(2)))'}>} RevAmt)

Works for April 2013 perfectly for this date: 04/01/2013

=Sum({$<RevMonth={'04/01/2013'}>} RevAmt)

Gysbert_Wassenaar — Fri, 26 Apr 2013 14:10:44 GMT

Try sum({$<RevMonth={'$(=Date(MonthStart(Today(2))))'}>} RevAmt)

Fri, 26 Apr 2013 15:29:10 GMT

Well that worked perfect! I guess I needed to add {'$(=... inside the modifier....

Thanks!