# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## sum of the last of 3 selected months

hi

i got the following problem:

i want to sum only the last month even if 3 or more months are in a listbox  selected.

at the moment  the expression looks like this:

sum ( {  \$ < TypeOfVoucher = { 'Sale' } , MonthNum = {  '9' '} >} Amount  )

I would be thankful for any advice.

greetings

daniel

1 Solution

Accepted Solutions
Not applicable

## Re: sum of the last of 3 selectes monts

Hello Marc,

thank for your good idea .

it led me to the right  solution.

the expression must  look like this:

sum ( { \$ < TypeOfVoucher = {'Sale'}  , MonthNum = {    \$ (=MAX (MonthNum ) )           }  > } Amount )

so long

daniel

Postscript: better type the whole expression without space characters.

2 Replies
Not applicable

## sum of the last of 3 selectes monts

Try this:

sum ( {  \$ < TypeOfVoucher = { 'Sale' } , MonthNum = {"=\$(=Max(MonthNum))"}>} Amount  )

Not applicable

## Re: sum of the last of 3 selectes monts

Hello Marc,

thank for your good idea .

it led me to the right  solution.

the expression must  look like this:

sum ( { \$ < TypeOfVoucher = {'Sale'}  , MonthNum = {    \$ (=MAX (MonthNum ) )           }  > } Amount )

so long

daniel

Postscript: better type the whole expression without space characters.

Community Browser