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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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