topic Re: How to show next 3 sum Values in QlikView

How to show next 3 sum Values

beck_bakytbek — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

i need your Advise /Hepl:

My issue / problem is: please see attached

i have a straighttable / pivot:

if i select in the row: Jan (one month ) i want to have in column: M +1 a Value: 20 ( it does mean: Jan take a value of Feb: 20)

column: M + 2 does mean: it consists of Value 20 (of Month Feb) and Value 30 (of Month Mrz)

column: M + 3 does mean: it consists of Value 20 ( of Month Feb) and Value 30 (of Month Mrz) and Value 0 (of Month Apr)

in conjunction with month, if i select, for instance: Nov+Dez+Jan + Feb (Jan and Feb are parts of next year), so i want to see this situation:

M+1 = Mrz

M+2 = Mrz + April

M+3 = Mrz + April + Mai

so the last month from the selection is the M.

Does anybody have any idea to resolve this issue?

Thanks a lot in advance

beck

Re: How to show next 3 sum Values

Chanty4u — Thu, 16 Feb 2017 09:40:52 GMT

try this

=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))

Re: How to show next 3 sum Values

sunny_talwar — Thu, 16 Feb 2017 09:46:12 GMT

Would you be able to provide a sample app to look at because the expression might change based on straight table or pivot table, but in your post you mentioned straighttable/pivot meaning it could be either. It might be easier to see what you have provide a solution, then to just keep on guessing

Re: How to show next 3 sum Values

beck_bakytbek — Thu, 16 Feb 2017 09:51:12 GMT

Hi Sunny,

first of all, thanks a lot for your response, Sunny if you see my attached. i showed my example. i use in my case a straight table.

Do you have any idea?

Thanks a lot

beck

Re: How to show next 3 sum Values

beck_bakytbek — Thu, 16 Feb 2017 09:52:20 GMT

Hi Chanty,

Thanks a lot for your respone,

i tried to impelement your solution, but t doesn't work,

thanks a lot

beck

Re: How to show next 3 sum Values

sunny_talwar — Thu, 16 Feb 2017 09:55:27 GMT

If it is three expressions one each for M + 1, M + 2, & M + 3, you can try this:

M + 1

Below(Value, 1)

M + 2

RangeSum(Below(Value, 1, 2))

M + 3

RangeSum(Below(Value, 1, 3))

Re: How to show next 3 sum Values

beck_bakytbek — Thu, 16 Feb 2017 12:14:00 GMT

Hi Sunny, thanks a lot for your suggestions,

but i think i explained wrong, my startposition:

if i select Month Jan (Costs = 5) must be ignored. and in my column :

M+ 1: i have the costs 20 ( 20 is from Month Feb), in column : M+ 2: i have costes 50 ( Feb + Mrz= 20 + 30) . and in column M+3: i have Costs 90 (Feb+Mrz+Apr= 20+30+40)

and if i select Jan and Feb , i need to see Month: Mrz = Cost(30)

i hope i explained enough well

Thanks a lot for your Advice / Help

beck

Re: How to show next 3 sum Values

sunny_talwar — Thu, 16 Feb 2017 12:15:27 GMT

Will it possible to share an app where you are trying to do this?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample