Qlik Community

Qlik Sense App Development

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

Not applicable

Cumulative measure using dimension

Hello from France

I ve got a nice question for you

DATE_Beg is my Dimension

I want to have 2 Measures on my graph.

The First is OK : Cumulative of Beginnings

rangesum( above( COUNT([ID_RECORD]),0,rowno()))

The Second False is easy to calculate but false:

rangesum( above( COUNT([DATE_End]),0,rowno()))

In effect, For my graph, I want the Cumul of RECORD who have ended at the date of the Dimension. It would be something like that...

rangesum( above( COUNT( {< DATE_End= {" < MAX(DATE_Beg)"} >}  DATE_End)

Do you have any idea of the way to calculate this second measure????

Thank you very much!!

Martin

1 Solution

Accepted Solutions
Not applicable

Re: Cumulative measure using dimension

I solved myself adding a new table IN SQL

1 Reply
Not applicable

Re: Cumulative measure using dimension

I solved myself adding a new table IN SQL

Community Browser