Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Four months trailing total for Quarter

Hi

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

5 Replies
Not applicable
Author

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

Anonymous
Not applicable
Author

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

arjunkrishnan
Partner - Creator II
Partner - Creator II

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

Anonymous
Not applicable
Author

Arjun/ Suraj

I appreciate your efforts

Let me try this and I will update

Thanks again

Anonymous
Not applicable
Author

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