Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolling 12 Months HELP!

Why is my expression giving me everthing and not just the past 12 months?

Getting really bored of trying to figure it out and all other posts are either going way over my head or i can't work out what i need to adjust to make them fit my report.

Any help will be much appreciated!

Elly

sum

({1<[HEADERS.Posting MonthEnd]={">=$(=addmonths(monthenddate(max([HEADERS.Posting MonthEnd]))+1,-12))

<=$(=max([HEADERS.Posting MonthEnd]))"
}>}

{1<
ITEM_UOM_GP.Brand={'2 DRAINAGE'}>}

{1<
[ITEM_UOM_GP.Reporting UOM Sub Sub Group]={'Accessories'}>}

(
Quantity )/1000)

20 Replies
Gysbert_Wassenaar

Maybe this:

sum

({1<[HEADERS.Posting MonthEnd]={">$(=addmonths(max([HEADERS.Posting MonthEnd]),-12)),

<=$(=max([HEADERS.Posting MonthEnd]))"},ITEM_UOM_GP.Brand={'2 DRAINAGE'},[ITEM_UOM_GP.Reporting UOM Sub Sub Group]={'Accessories'}>}

(Quantity )/1000)

If not, please post the document you're working on.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi

Thank you for your fast resoonse.

I've attached a censored version for you to look at.

Thanks

Elly

Gysbert_Wassenaar

Ah, you're using the monthend field as a dimension. Then set analysis won't help. The set is calculated first and then the chart expressions are applied to the set. The set is not calculated per row, so it can't take the row-value of monthend into consideration. You'll have to use what some of us call an AsOf table. See here for that approach.


talk is cheap, supply exceeds demand
Not applicable
Author

I was hoping you weren't going to say that.

I've seen those in other posts but i really don't understand what i need to do to make them work.

I need an idiots guide, but i'm guessing idiots shouldn't be using Qlikview!

Not applicable
Author

If i changed the Dimension would i still need to use 'As Of Date'?

Not applicable
Author

hi there, do u want your axis x to display at date or can it display like Jan 2013 format?

Not applicable
Author

Hi Nick

Whichever to be honest, all i'm interested in 12 rolling data and for it to state what month and year it is. Whether it's 28/02/13 or Feb 13 is not a problem.

Not applicable
Author

can you store all your table in QVD, zip it and attached it here.

with qvw i can't reload.

Not applicable
Author

ha ha ha ha ha! That is a very good question!

I'll see what i can do, give me a few minutes.