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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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