topic Maintaining data over date ranges in QlikView

Maintaining data over date ranges

Tue, 22 Sep 2009 22:22:12 GMT

I have a project that I am working on that will show project status and sales stage information in a give time period. This information is coming from two seperate systems. I want to view the counts of the various statuses and stages over a given timeframe, usually over a year. The problem that I am have is when I select a sales stage I loose several months of project status data. Is there any way to maintain the project status data, even when selecting a sales stage causes some dates to be excluded?

Thanks!

Maintaining data over date ranges

Tue, 22 Sep 2009 23:09:31 GMT

You can do it using set analysis. Suppose you don't want any selection to effect the sum(Sales), you can write

sum({1} Sales)

Thus the sum(Sales) will be always constant irrespective of any selections made.

Maintaining data over date ranges

Tue, 22 Sep 2009 23:19:01 GMT

Richy,

Thank you for your suggestion. I would like to be able to select the date range initially and not have the project status or sales stage affect the selected date range. Any thoughts on that?

Maintaining data over date ranges

Tue, 22 Sep 2009 23:25:51 GMT

what is going to be the date range? Is it a dynamic value like last 12 days?

Or is it what you can select ?

Maintaining data over date ranges

Tue, 22 Sep 2009 23:29:59 GMT

i have three list boxes where a user can select a month, day and year.

Maintaining data over date ranges

Thu, 24 Sep 2009 10:48:40 GMT

HI, sorry for the delay. It seems like your interests are conflicting. You want to show the graph according to the date range selected. That means if you select stage, it will reflect in the date range and in turn it will it affect the graph as well.

One way you can achieve this is by creating a loosely coupled table which has data only needed for the graph you want to show.i.e. a table isolated from all other entities, which can be done from load script. This way the selection of the date range will affect only the chart, not any other product or whatever it is, and vice versa

Anyway, see what others are saying. Maybe somebody can help you out.