Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Selgum
Contributor
Contributor

Last year combined with other Expression

Hi there,

 

Probably a newbie question.

 

I have this this statement which I would like to include "last year" aswell

sum( {$<RappGrpNavn = P({1<RappGrpNavn={'*web*'}>} RappGrpNavn)>} Salgspris)

 

Have tried this, but doesnt do the trick

Sum({$<Year={$(=Max(Year)-1)}>}{$<RappGrpNavn = P({1<RappGrpNavn={'*web*'}>} RappGrpNavn)>} Salgspris)

Hope you guys can sort it out.

Thanks in advance

Labels (2)
1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

Hi,

change it to

Sum({$<Year={$(=Max(Year)-1)}, RappGrpNavn = P({1<RappGrpNavn={'*web*'}>} RappGrpNavn)>} Salgspris)

Regards

View solution in original post

2 Replies
martinpohl
Partner - Master
Partner - Master

Hi,

change it to

Sum({$<Year={$(=Max(Year)-1)}, RappGrpNavn = P({1<RappGrpNavn={'*web*'}>} RappGrpNavn)>} Salgspris)

Regards

Selgum
Contributor
Contributor
Author

Super. That did it.

Thanks 🙂