Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
Hi
Thank you for your fast resoonse.
I've attached a censored version for you to look at.
Thanks
Elly
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.
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!
If i changed the Dimension would i still need to use 'As Of Date'?
hi there, do u want your axis x to display at date or can it display like Jan 2013 format?
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.
can you store all your table in QVD, zip it and attached it here.
with qvw i can't reload.
ha ha ha ha ha! That is a very good question!
I'll see what i can do, give me a few minutes.