topic Help! Graphical values to the Previous Month in QlikView

Help! Graphical values to the Previous Month

Fri, 24 May 2013 14:57:26 GMT

How do I bring in a graph with the dimension month and the expression Sum ([amount billed]) where the value to the previous month?

May Today we want him to bring me the value only until the end of April

Any Idea?

Att,

João Henrique

Fri, 24 May 2013 15:15:08 GMT

Hi try this

=sum({<[date]={">=$(=MonthStart(date),-1))<=$(=MonthEnd(date),-1))"},Year=,Month=,Quarter=>}amountbilled)

I hope this is helpfull to you

Regards

Bharathi

juleshartley — Fri, 24 May 2013 15:36:53 GMT

I would make a variable vLastMonth =Date(MonthsEnd(1,Now(),-1),'DD/MM/YYYY')

Then use set analysis similar to Bharathi above:

=sum({$

//Remove any date selections if they are affecting your data set

Year=,

Month=,

Quarter=,

//apply the filter to your date field

[date]={"<=$(=vLastMonth )"}

}amountbilled)

Fri, 24 May 2013 17:09:06 GMT

Thank you! in a few days I will have to test!

Fri, 24 May 2013 17:09:27 GMT

Thank you!