Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, i'm trying to do a simple chart comparing Current YTD volume versus Budget YTD (see image)
The Current YTD expression is correct: sum({<Year={"$(=Year(today()))"}>} InvoiceQty)
But i'm struggling with expressing all this years budget volume upto and including the current month.... See no current month budget number!!!
Here's the expression:
sum({<Year={"$(=Year(today()))"}, EndOfMonth={"<=$(=MonthEnd(today()))"}>} BudgetVolume)
I've searched through many examples of this type of problem on the community and adapted the expression accordingly, but it still excludes the current month budget volume.... Any ideas Qlikviewers?
I am unable to understand why you say that YTD expression is correct when your YTD (28/02/2011) is less than YTD (31/01/2011).
If you attach your application with sample data, someone in the forum will be able to come up with some suggestions.
Sorry... I beg your pardon... both columns aren't accumulating at this point.... they are expressing values for the dimensions customer number and endofmonth so that you can clearly see that the budget number for the current month is missing.... once i've validated that the information is correct i'll be removing the endofmonth dimension to show a single row for each customer..... hope this makes sense...
You have to make sure that the Date Format is the same for both EndOfMonth and MonthEnd(Today()).
Another option would be to put MonthEnd(Today()) as a variable with the correct formatting. Then have your set analysis <= your variable.
Within the creation of a linktable in my edit script i have:
MonthEnd(InvoiceDate) as EndOfMonth,
MonthEnd(BudDate) as EndOfMonth,
Therefore, should a <= comparison with MonthEnd(today()) be ok?
I'll try using a variable in the meantime...
Cheers
I would think this should be OK. You could find out for sure by putting them in a text box to see if the formats are the same.