Rangesum Above Dimension Problem

alucard_ae86 — Sat, 16 Nov 2024 04:51:27 GMT

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

Re: Rangesum Above Dimension Problem

sunny_talwar — Fri, 04 Jan 2019 12:49:11 GMT

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

topic Re: Rangesum Above Dimension Problem in QlikView

Rangesum Above Dimension Problem

Re: Rangesum Above Dimension Problem