Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
Partner

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
Partner

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 🙂