Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

Prior month by selected month

Hi!

How i can get prior month from by selected month ?

For example, if i choose october, i need to get september

Thank you!

There is attached model

1 Solution

Accepted Solutions
MVP
MVP

Re: Prior month by selected month

Try:

=Sum({<Month={"$(=Month(AddMonths(Max(Date),-1)))"}>}Quantity)

3 Replies
hrlinder
Honored Contributor

Re: Prior month by selected month

where you want to get the previous month?

can you explain mor eindetail within your application?

you can use addmonths for instance

addmonths(date,-1) will get you the previous month

MVP
MVP

Re: Prior month by selected month

Try:

=Sum({<Month={"$(=Month(AddMonths(Max(Date),-1)))"}>}Quantity)

andreyfcdk91
New Contributor III

Re: Prior month by selected month

Perfect!

Thank you.

Community Browser