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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
mahieuphilippe
Creator
Creator

Create a expression by line with the cumul

Hi everybody 

 

I don't find a solution for this topic

 

in Qliksense i have a table  

 

Dimension : year (date) & '-' & num (month (date),'00')

 

Expression :  median (aggr ((Num#(Interval(FirstPublicReply - date, 'ss'))/60),ticketid, date))

 

mahieuphilippe_1-1756971787132.png

 

 

I want to have the total résult  but line by line 

 

so this result 

 

mahieuphilippe_2-1756971997778.png

with this formula i have the final result but not month by month  always the final result (4,58)

Median(TOTAL Aggr((Num#(Interval(FirstPublicReply - date, 'ss'))/60), ticketid, date))

mahieuphilippe_3-1756972183639.png

 

 

and not this 

mahieuphilippe_4-1756972270800.png

thank you to help me 🙂   Phil

 

 

 

Labels (1)
2 Replies
FedericoDellAcqua
Creator II
Creator II

Have you tried using the modifiers included in the measure?

FedericoDellAcqua_0-1756975838501.png

 

mahieuphilippe
Creator
Creator
Author

Hi thanks for your reply non this is the result 🙂

 

 

mahieuphilippe_0-1756977140131.png