Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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 (1)
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 🙂