topic Re: cumulative in QlikView

cumulative

sagaraperera — Thu, 30 Apr 2015 02:42:37 GMT

I want to look comprise the month profits cumulative value statement. When changes need to be modified according to the cumulative Is Suggested relating month.

Directory;

LOAD BCOD,

CODE,

MONM,

NOTES,

NOTE_DESC,

AC_GP,

MONTH,

MONTH2,

YEAR,

CLA_CODE,

BUDGET

FROM

G:\qlickviwe\P&L\EXPBUDDATA2015.QVD

(QVD);

Concatenate

LOAD BCOD,

CODE,

MONM,

NOTES,

NOTE_DESC,

AC_GP,

MONTH,

MONTH2,

YEAR,

CLA_CODE,

ACTUAL

FROM

G:\qlickviwe\P&L\EXPDATA2015.QVD

(QVD);

Directory;

LOAD NO,

ACCOUNTANT,

AC_NO,

BCOD,

REGION,

BRA_CAT,

BRA_DBASE,

BRANCH,

DEPT

FROM

[.. \ .. \ Qlickviwe \ Branch.qvd]

(QVD);

Re: cumulative

Thu, 30 Apr 2015 03:14:46 GMT

Your requirement not clear. Please explain in detail with example.

Rgds.

Priyantha.

Re: cumulative

sagaraperera — Thu, 30 Apr 2015 04:05:13 GMT

mata ona wenne month eka select karanakota month coulum eka samaga p& l eke wage cumulative column eka anek patten column ekak hadaganna. habai mase wenas karanakota eata sapekshawa cumulative wenas wenna ona. month oeka march select kala vita january, feb,march masa thunema ekathuwa cumulative clum eke penviya ona. month column eke march pen wanna ona.

please help me

sagara

Re: cumulative

Thu, 30 Apr 2015 04:53:26 GMT

Dear Sanka,

Simply you can do this,

Select three months together in your list box(MONTH).

Re: cumulative

sagaraperera — Thu, 30 Apr 2015 05:15:13 GMT

Mr.Priyantha,

ehema select kala vita month ekai cumulative ekai dekama ekama value

gannawa mata ona month colum eke month value ekai cumulative column eke

month wala ekathuwai wena wenama. see gven below

On 30 April 2015 at 10:23, PRIYANTHA BANDARA <qcwebmaster@qlikview.com>

Re: cumulative

sagaraperera — Thu, 30 Apr 2015 05:16:38 GMT

Mr.Priyantha,

ehema select kala vita month ekai cumulative ekai dekama ekama value gannawa mata ona month colum eke month value ekai cumulative column eke month wala ekathuwai wena wenama. see given below.

Re: cumulative

Thu, 30 Apr 2015 05:50:01 GMT

Sanka,

What do you mean by 'month' and 'month1' in your script?

Re: cumulative

Thu, 30 Apr 2015 05:51:39 GMT

So you have done the thing you expected. what else?

Re: cumulative

Thu, 30 Apr 2015 07:13:58 GMT

Sanka,

You can use the accumulate option in Expression properties.