Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with Set Analysis Dynamic Date

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)

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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

Thanks!