Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have hit another road block. List box contents is Month-Year then how can we achieve the following:
On reload I have scheduled an action of selecting the max Month-year in this case Jan 2014.
My requirement is on reload (Month-Year selected Jan-2014)
Chart 1 should be Jan 2013 Chart and Chart 2 should be Jan 2014.
Similarly when Feb 2013 is selected
Chart 1 should be Feb 2012 Chart and Chart 2 should be Feb 2013 and so on and so forth
Check this..
You have been provided with month year listbox or you have created it in qlikview?
can u post your qvw file it easy for us to do changes on ur file
Set analysis for the expressions in both graphs: The first one MonthYear(Max(=Monthyear)-1) and the second one (MonthYear(Max(=Monthyear))
It has been provided.
This wont work since MonthYear returns string.
I am sorry, but due to confidentiality I cannot.
Try with a dollar sign expansion.
sum({$<MonthYear={$(=Max(MonthYear)}>}Sales)
or
sum({$<Month={$(=Max(Month)},Year={$(=Max(Year)}>}Sales)
Depenedent on what kinda fields you have, that works for me at least.
Does that help?
Hi,
For chart 1,
Keep dimension as Monthyear and expression as =sum({$<Monthyear={"$(var)"}>} sales)
where var is variable and its value is =left(Monthyear,3)&'-'&num(num(Right(Monthyear,4))-1)
and for chart 2,
leave keep dimensions and expressions normally
I think there is a slight misunderstanding, field name is Buying Month and the data fetched for that field is Jan 2012, Feb 2012, March 2012...and so on.
I do not have separate fields Month and Year.