Dynamic Display of Charts

[shannoypaul]

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

[#2]

You have been provided with month year listbox or you have created it in qlikview?

[arsal_90]

can u post your qvw file it easy for us to do changes on ur file

[#4]

Set analysis for the expressions in both graphs: The first one MonthYear(Max(=Monthyear)-1) and the second one (MonthYear(Max(=Monthyear))

[shannoypaul]

It has been provided.

[shannoypaul]

This wont work since MonthYear returns string.

[shannoypaul]

I am sorry, but due to confidentiality I cannot.

[#8]

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?

[#9]

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

[shannoypaul]

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.