Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dmv15956
Contributor

Cummulative Total

Hi All,

I am trying to get cumulative total numbers in charts or in table in Qliksence.

I have attached the excel file for example.

1 Solution

Accepted Solutions
MVP
MVP

Re: Cummulative Total

Sample image and sample qvf attached

Capture.PNG

8 Replies
agigliotti
Honored Contributor II

Re: Cummulative Total

you can use the below expression for the measure:

rangesum( above( count( id number), 0, rowno(total) ) )

MVP
MVP

Re: Cummulative Total

Something like this

=RangeSum(Above(Count(DISTINCT {<Completed = {'N'}>} [ID Number]), 0, RowNo()))

MVP
MVP

Re: Cummulative Total

Sample image and sample qvf attached

Capture.PNG

mdmukramali
Valued Contributor II

Re: Cummulative Total

Hi,

find the attached sample App.

297077.PNG

dmv15956
Contributor

Re: Cummulative Total

Thanks Sunny. This work.

I would also like to show current month bar in charts.

Examples if current month is Jan'18 and although we do not have any entry in jan'18, then I would like show dec'17 number also in Jan'18.  Which means we are carry forwarding this number.

Capture.JPG

MVP
MVP

Re: Cummulative Total

There is no Jan 2018 in the attached application... also, if you would like to do that... then use MonthYear field rather than using Month field

Capture.PNG

dmv15956
Contributor

Re: Cummulative Total

yes I am using monthyear function. But I want to copy Dec'17 number in Jan'18.

Basically I would like to show 1 extract month copying previous month number.

MVP
MVP

Re: Cummulative Total

I understand, but the Jan-18 have to be in the dashboard to show up right? The value Jan-18 doesn't exists in Month Year field... may be you can create it using a master calendar where you have one extra month... but you need Jan-18 under Month Year to make this possible....

Just to show as an example... I added it like this

Table:

LOAD

    "ID Number",

    "Created on",

    Month([Created on]) as [Created Month],

    MonthName([Created on]) as [Created Month Year],

    "Required End",

    "Actual End Date",

    "Completn date",

    Completed

FROM [lib://Lib/Need Help.xlsx]

(ooxml, embedded labels, table is DATA);


Concatenate (Table)

LOAD MonthName(MakeDate(2018, 01, 01)) as [Created Month Year]

AutoGenerate 1;

And then this expression

=RangeSum(Above(Count(DISTINCT {<Completed = {'N'}>} [ID Number]) + Sum({1} 0), 0, RowNo()))

Capture.PNG

Community Browser