Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Cumulative measure by one Dim for pivot table that has multiple Dims

Hello...

I have a normal sum as shown in first column and cumulative sum over a date as shown in second column

images (1).png

 

 

 

and there are more details under that date...

the problem that the measure sum cumulatively under those dimensions when be expanded which will not be logical...

images (2).png

 

 

 

what I want is to make that cumulative sum to be repeated for all children of that date..

is that possible...

this what I the measure say: 

RangeSum(Above(Count({$<COMPLETE_STATUS_DESC={'something'},F_CENS_ID={1}>} distinct UNIT_ID ), 0, RowNo()))

Labels (1)
2 Replies
Highlighted

May be use dimensionality() function to use two different expressions for two different levels.

If(Dimensionality() = 2,
Count(TOTAL <Date> {$<COMPLETE_STATUS_DESC={'something'},F_CENS_ID={1}>} distinct UNIT_ID ),
RangeSum(Above(Count({$<COMPLETE_STATUS_DESC={'something'},F_CENS_ID={1}>} distinct UNIT_ID ), 0, RowNo()))
)
Highlighted
Digital Support
Digital Support

Did Sunny's post get you what you needed for you use case?  If so, do not forget to return to your thread and on his post, use the Accept as Solution button to give him credit for the help and let other Members know this suggestion worked for this use case.  If you are still working on things, please leave an update and if figured out some other solution, please consider posting that in a new comment, then use the button to mark that as the solution in that case to close out the thread.

The only other thing I have is the Design Blog area, here is the base URL from where you can search the posts in that area, most of them are how-to related from our internal experts, you may find some ideas there too.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.