topic Re: Cummulative Calculation in QlikView

Cummulative Calculation

Tue, 21 Feb 2012 11:30:01 GMT

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.

Re: Cummulative Calculation

Tue, 21 Feb 2012 12:26:24 GMT

Hi,

please see the attached example for help.

Good Luck!

Rainer

Re: Cummulative Calculation

Tue, 21 Feb 2012 13:33:15 GMT

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.

Re: Cummulative Calculation

v_iyyappan — Tue, 21 Feb 2012 14:04:05 GMT

Hi ,

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

Regards,

Iyyappan

Re: Cummulative Calculation

Fri, 02 Mar 2012 05:30:44 GMT

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.

Re: Cummulative Calculation

v_iyyappan — Fri, 02 Mar 2012 06:00:07 GMT

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

Re: Cummulative Calculation

Fri, 02 Mar 2012 06:06:11 GMT

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