topic Re: Cummultive trics in QlikView

Cummultive trics

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

Hi All,

I have a very complicated requirement . which I am not able to do it from so many days ,

I hope this i will get some from this formum

Basically i have to show a table with the dimension 'Start Date'

and expression a Sum( JIraTIcket).

Below are some sample data and my outout

Input Dta		Desired Ouput		Cummulative
WeekStart	JIrTickes	WeekStart	JIrTickes		WeekStart	JIrTickes
1-Mar-20	1	1-Mar-20	1		1-Mar-20	1
8-Mar-20	1	8-Mar-20	1		8-Mar-20	2
15-Mar-20		15-Mar-20	1		15-Mar-20	3
22-Mar-20	2	22-Mar-20	2		22-Mar-20	4

If you look into the first table which is the input , well in this the data on 15-mar is missing , therefore in my desired table it shoud keep the value of the prious date and contineu the same till it gets any new jira tickets, .

I trid this using range sum finction but that doensot help me .

Can someone please help me n this

Re: Cummultive trics

Frank_Hartmann — Sat, 21 Mar 2020 12:58:41 GMT

script:

LOAD * INLINE [
WeekStart, JIrTickes
1-Mar-20, 1
8-Mar-20, 1
15-Mar-20,
22-Mar-20, 2
];

straight table (uncheck "omit zero values" on presentation tab):

dim: WeekStart

exp1: if(sum(JIrTickes)=0, above(sum(JIrTickes)),sum(JIrTickes))

exp2: RangeSum(Above(if(sum(JIrTickes)=0, above(sum(JIrTickes)),sum(JIrTickes)),0,RowNo()))

Re: Cummultive trics

smilingjohn — Wed, 01 Apr 2020 05:49:52 GMT

Hi Frank thanks for the reply

Re: Cummultive trics

smilingjohn — Mon, 23 Mar 2020 10:15:16 GMT

Any Solution on this would be really helpfull

Re: Cummultive trics

Frank_Hartmann — Mon, 23 Mar 2020 16:00:56 GMT

can u share the qvw? maybe with reducing the datamodel to the essential data and then scrambling remaining sensitive fields (settings - docsettings - scrmbling).