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

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
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 🙂