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: 
shannoypaul
Creator
Creator

Dynamic Display of Charts

Dynamic Chart Display.jpg

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

1 Solution

Accepted Solutions
Not applicable

12 Replies
Not applicable

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

arsal_90
Creator III
Creator III

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

Not applicable

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

shannoypaul
Creator
Creator
Author

It has been provided.

shannoypaul
Creator
Creator
Author

This wont work since MonthYear returns string.

shannoypaul
Creator
Creator
Author

I am sorry, but due to confidentiality I cannot.

Not applicable

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?

Not applicable

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
Creator
Creator
Author

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.