topic Another Date Set Analysis question in QlikView

Another Date Set Analysis question

Wed, 23 Sep 2009 04:24:33 GMT

I'm trying to do something apparently very simple which is a value from a previous month, but I just can't get it. I've tried with:

sum({1<Date={'$(=Addmonths(Date,-1))'}>} Amount)

but it doesn't work. Can anyone point out what's wrong?

Another Date Set Analysis question

Wed, 23 Sep 2009 04:41:14 GMT

I think your Set Analsysis is requiring the Date to be one month less than itself. I think that will always be the empty set.

I used this (with a variable in the AddMonths) and it worked:

Sum({<Date = {'$(=AddMonths('$(=vDate)', -1))'}>}Amount)

Remember, you can see what you dollar sign expansion evaluates to be placing the expression in a straight table and not using a label. If you expand out that column, you will see your Set Analysis expression with the dollar sign expansion evaluated.

Another Date Set Analysis question

Wed, 23 Sep 2009 04:48:45 GMT

Thanks for your answer.

That would help me if the comparison date was always static, but basically what I'm attempting to do is have a pivot table with the Monthname(Date) as a dimension, and as expression the sum of Amount from the previous month. I hope that made sense

Another Date Set Analysis question

Wed, 23 Sep 2009 04:58:31 GMT

I forgot to add, I've tried using below, but it's not working either..