Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

group results

Hello,

I am back for another problem, that I couldn't find out.

For each "Code groupement", I have machines.

The machines are grouped by lines. For exemple:

on the image 1: machine Architect plus i2000sr and Immulite 2000xpi are on the same line.

I managed to have the technical time on 1 machine, per month. The formular used is :

sum(total<Machine,Month> aggr(sum([Nbr analyses]/[Cadence Chgt Tech])+sum([Nbr analyses]/[Cadence Manip Tech])+[Temps Set up annuel],Month,Machine))

But i wanted to display the total technical time of all machines which are on the same line.

So for example, both Architect plus i2000sr et Immulite 2000xpi have to display : 121,792xxxxx (which is 83,612xxx + 38,18xxxx)

I doubt to use the same formular above, but need to change a bit so that i can be grouped by lines.

Can anyone help me to find out?

Thanks very much

ex qliksens 1.PNG

Tags (1)