Create a expression by line with the cumul

mahieuphilippe — Thu, 04 Sep 2025 07:50:59 GMT

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))

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

so this result

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))

and not this

thank you to help me 🙂 Phil

Re: Create a expression by line with the cumul

FedericoDellAcqua — Thu, 04 Sep 2025 08:50:52 GMT

Have you tried using the modifiers included in the measure?

mahieuphilippe — Thu, 04 Sep 2025 09:11:43 GMT

Hi thanks for your reply non this is the result 🙂