Qlikview Expression

[#1]

Hi,

wanted to ask how i can achieve the following task:

If I have a dimension date and I make a selection on any date, I expect that it should show me the cumulative sales from monthstart till the selected date. How I can achieve it?

My suggestion would be to use Set Analysis, or i am wrong?

Thanks,

Patric

[swuehl]

For example use this in a text box:

=Sum({<date = {">=$(=Date(MonthStart(Max(date))))<=$(=Date(Max(date)))"}>} sales)

Assuming date and sales are your field names, date dimension is a correctly interpreted date in standard date format.