Cummulative Calculation

[#1]

Hi All,

         Can you please have a look into this excel file, where the MTD column calculation should be done in qlikview, is there anyone done already this kind of things.

Regards,

Ravi.

[#2]

Hi,

please see the attached example for help.

Good Luck!

Rainer

[#3]

Hi,

      I really appreciate your work, but i needed in text box not in a dashboard. If i select any date then it should come.

Regards,

Ravi.

[v_iyyappan]

Hi ,

     i attached sample QV file using MTD calculation. May be its helpful for u..

Regards,

Iyyappan

[#5]

Hi Riner and Ayyappan,

                                       Thanks for quick replies on my requirement but sorry for late replies to you.

It seems okay, but i need to apply for QTD And YTD logic, if you can add some inputs on it, really good.

Regards,

Ravi.

[v_iyyappan]

Hi,

     Using the Script,

Load *,

    Year(Date) as Year,

    Month(Date) as Month,

    Day(Date) as Day,

    Num(Date) as NumDate,

    Ceil((Month(Date) *1) /3) AS Quarter;

LOAD

    Date(Date#(Date,'MM/DD/YYYY')) as Date,

     Data1,

     Data2

FROM

CumulativeCalculation.xlsx

(ooxml, embedded labels, table is Sheet1);

YTD Expression

=Sum({<Year=,

        Month=,

        Quarter=,

        Day=,

        NumDate={'>=$(=(Num(YearStart(vSelectedDate))))<=$(=(Num(vSelectedDate)))'}>}Data1)

QTD    

     =Sum({<Year=,

             Month=,

             Quarter=,

             Day=,

             NumDate={'>=$(=(Num(QuarterStart(vSelectedDate))))<=$(=(Num(vSelectedDate)))'}>}Data1)

Where vSelectedDate = MakeDate(Max(Month),Max(Month),Max(day))

Regards,

Iyyappan

[#7]

Thanks..Man..Let me try and get back to u on it.