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
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
GeromA
Contributor II
Contributor II

Sum with multiple conditions

Hi all,

trying to create a formula in a chart that would give me the value of a previous year (as part of a another calculation). The below give me the correct value for the current year (year(DATE)) but not for the previous one (year(DATE)-1):

fabs(sum({$<[Criteria1]={'86','87','88','89','93','94','95'},[year(DATE)]={[year(DATE)-1]}>}VOLUME))

 

Appreciate your ideas to solve this.

Many thanks.

Labels (1)
2 Replies
PradeepK
Creator II
Creator II

There are different rules for assigning values to Set Modifiers.

Use Below link.. for reference.

Set-Analysis-with-yearstart-and-yearend-dates-not-working 

GeromA
Contributor II
Contributor II
Author

Dear PradeepK,

thanks for the link. I'm, however, not able to modify the my code in a way it would bring up the correct result.

Would you have a solution for the code?

Many thanks,

GeromA