Active selections

Thu, 02 Feb 2012 10:48:11 GMT

Hello,

I have some problems (maybe very basic) with selections.

I have a field: Sales_Month. This field contains months from 2002 till current date, loaded from the sales date records.

1) it doesn't contains all the months, if the firm has not sell anything on march 2008 I don't load Mar 2008. What I have to do in order to load all months?

2) I need a graph with years > 2009 only so I want a list box containing Sales_Month field, but it should show only 2012, 2011, 2010 months.

3) I want to make this condition editable by the users: for example the user could set 2010 and the graphs and the listbox will show only 2012 and 2011 months.

4) I need a graph that shows a 12 months rolling range. The user set a month for example jun 2010, and the graph shows the sales trend from jun 2010 to may 2011 only!!!

I'm sorry if these question are too basic and if I don't speak english very well.

Active selections

nilesh_gangurde — Thu, 02 Feb 2012 11:22:26 GMT

Heyy,

First you implement the Master Calander in your application.

and if you are using the QlikView 11 then its New feature "Dimension limit" u can use for graph which shows the months of 2012,2011 $2010.

Regards,

Nilesh Gangurde

topic Active selections in QlikView

Active selections

Active selections