topic Re: Four months trailing total for Quarter in QlikView

Four months trailing total for Quarter

Anonymous — Wed, 09 Apr 2014 00:55:41 GMT

I appreciate your help.

I have attached QV file, in that I need four month trailing(Current Quarter + previous 1 month) total for particular quarter.

Please have a look on attached QV file

Thanking you for your time and efforts

Re: Four months trailing total for Quarter

Wed, 09 Apr 2014 02:04:52 GMT

Create a new column, if((Month=Dec, Jan, Feb, Mar, Apr), Q1, if((Month= Mar, Apr, May, Jun), Q2, ........!! Use it as a dimension and sum it. Hope this works.

Suraj

Re: Four months trailing total for Quarter

Anonymous — Wed, 09 Apr 2014 10:32:22 GMT

Suraj,

My quarter is going to be the same Jan-Feb-Mar than Q1, Apr-May-Jun than Q2

But with in this quarter I need four trailing month sum for division

Thanks

Re: Four months trailing total for Quarter

arjunkrishnan — Wed, 09 Apr 2014 10:57:40 GMT

Hai Satish ,

I try This One I hope U I will vry Useful for ...Pls find my Qvw...

O/p Like That

I Should Little bit Changes Happen On U r App ..Pls Show THis

Re: Four months trailing total for Quarter

Anonymous — Wed, 09 Apr 2014 11:54:36 GMT

Arjun/ Suraj

I appreciate your efforts

Let me try this and I will update

Thanks again

Re: Four months trailing total for Quarter

Anonymous — Thu, 10 Apr 2014 01:55:25 GMT

Hello Arjun

With particular selection it works fine but without selecting any year/quarter there is no value in row

Because with selection it become static, in this case dimension is variable

Thanks for your effort