cumulative

[sagaraperera]

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);

[#2]

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

Rgds.

Priyantha.

[sagaraperera]

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

[#4]

Dear Sanka,

Simply you can do this,

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

[sagaraperera]

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>

[sagaraperera]

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.

[#7]

Sanka,

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

[#8]

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

[#9]

Sanka,

You can use the accumulate option in Expression properties.