Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Maintaining data over date ranges

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!

5 Replies
Not applicable
Author

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.

Not applicable
Author

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?

Not applicable
Author

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

Or is it what you can select ?

Not applicable
Author

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

Not applicable
Author

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.