topic Re: Dynamic Display of Charts in QlikView

Dynamic Display of Charts

shannoypaul — Thu, 27 Mar 2014 08:02:52 GMT

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

Re: Dynamic Display of Charts

Thu, 27 Mar 2014 08:27:31 GMT

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

Re: Dynamic Display of Charts

arsal_90 — Thu, 27 Mar 2014 08:30:34 GMT

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

Re: Dynamic Display of Charts

Thu, 27 Mar 2014 08:37:53 GMT

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

Re: Dynamic Display of Charts

shannoypaul — Thu, 27 Mar 2014 09:09:06 GMT

It has been provided.

Re: Dynamic Display of Charts

shannoypaul — Thu, 27 Mar 2014 09:10:18 GMT

This wont work since MonthYear returns string.

Re: Dynamic Display of Charts

shannoypaul — Thu, 27 Mar 2014 09:12:08 GMT

I am sorry, but due to confidentiality I cannot.

Re: Dynamic Display of Charts

Thu, 27 Mar 2014 09:52:09 GMT

Try with a dollar sign expansion.

sum({$<MonthYear={$(=Max(MonthYear)}>}Sales)

sum({$<Month={$(=Max(Month)},Year={$(=Max(Year)}>}Sales)

Depenedent on what kinda fields you have, that works for me at least.
Does that help?

Re: Dynamic Display of Charts

Thu, 27 Mar 2014 10:02:48 GMT

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

Re: Dynamic Display of Charts

shannoypaul — Thu, 27 Mar 2014 10:06:58 GMT

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.

Re: Dynamic Display of Charts

Thu, 27 Mar 2014 10:12:03 GMT

Hi Aakansha,

Nice it's working properly

Re: Dynamic Display of Charts

Thu, 27 Mar 2014 10:29:27 GMT

Check this..

Re: Dynamic Display of Charts

shannoypaul — Thu, 27 Mar 2014 13:23:28 GMT

Thanx a lot guys, It worked