Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with table

HI,

i would like to cumulate the number of hours in the year based on a calender and moissequentiel, this is the formula:

sum({$<MoisSequentiel = {">$(#=(MoisSequentiel-12))<=$(#=MoisSequentiel)"}>}Heures)


and i integrated the formula ina if for that only the month  that can cumulate can show their results:


=if(MoisSequentiel-12>=0  and sum({$<MoisSequentiel=p(MoisSequentiel)>} Heures)<>0 ,

sum({$<MoisSequentiel = {">$(#=(MoisSequentiel-12))<=$(#=MoisSequentiel)"}>}Heures) ,

if(MoisSequentiel-12<=0,0))

the result is:

1.PNG

the result is the number of hours for the month and not the cumulation for the 13 month preceding this month.

thanks for  help, i have joined the excel file and the application.

1 Reply
sunny_talwar

The app contains no data, can you repost the app with the data and chart to take a look at this?