Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Help! Graphical values ​​to the Previous Month

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

1 Solution

Accepted Solutions
juleshartley
Valued Contributor

Re: Help! Graphical values ​​to the Previous Month

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)

4 Replies
Not applicable

Re: Help! Graphical values ​​to the Previous Month

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
Valued Contributor

Re: Help! Graphical values ​​to the Previous Month

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)

Not applicable

Re: Help! Graphical values ​​to the Previous Month

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

Not applicable

Re: Help! Graphical values ​​to the Previous Month

Thank you!

Community Browser