Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alucard_ae86
Contributor
Contributor

Rangesum Above Dimension Problem

Hello Experts,

I have calculated stock of some materials  by using the following expression 

RangeSum(Above(
Sum({$<MVMNT={'000','001','004','005','006','010'},DATE={"<$(vDateTo)"}>}STOCK), 0, RowNo()))
-
RangeSum(Above(
Sum({$<MVMNT={'100','101','104','105','106','110'},DATE={"<$(vDateTo)"}>}STOCK), 0, RowNo()))

so i display by date using the expression 

=if( DATE>= $(vDateFrom) and DATE<= $(vDateTo) , Date(DATE,'DD/MM/YYYY'),Date($(vDateFrom),'DD/MM/YYYY') )


 I want to calculate the change of stock by Date comparing with 1 year prior but when i use this expression I have to display all rows to get the right results but i want only to display a range of dates

RangeSum(Above(
Sum({$<MVMNT={'000','001','004','005','006','010'},DATE={"<$(vDateTo)"}>}STOCK), 365, RowNo()))
-
RangeSum(Above(
Sum({$<MVMNT={'100','101','104','105','106','110'},DATE={"<$(vDateTo)"}>}STOCK), 365, RowNo()))

Thanks in Advance

Regards

Labels (3)
1 Reply
sunny_talwar

Would you be able to share a sample to show what you have so far?