Qlik Community

Qlik Sense App Development

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

Not applicable

Subtract agregation from two dimensions


I'm very new to qlik and I'm struggling with the desktop version to analyze our helpdesk ticketing tool. I'm trying to draw the evolution of our backlog (tickets opened - ticket closed by month).

I have two dimensions: creation date (per month) and closed date (per month). I'm playing with to tables.

The first one has:

- Dimension= opened date

- Measure= rangesum(above(count(ID),0,rowno()))

The second one has:

- Dimension =closed date

- Measure=rangesum(above(count(ID),0,rowno()))

But I don't know how to put it together in order to have cumulative opened - cumulative closed, I don't know how to play it in the same table/chart in order to subtract the two values.

Could you please help me on it?

Thank you!