Make Filters Only Effective on the Sheet They're On?
I have a main tab that has 15 minute interval data being displayed however I give options to select multiple intervals, sites, etc. I then have another tab that is displaying charts of all this data historically (not an instance in time).
Is there any way to make the filters on my main tab only effect data on my main tab and then make filters on my chart tab only effect the chart time?
In addition, for the chart tab, are there filters available to display 'Last 24 Hours', 'Last Week', 'Last Month', etc. as well as specifying a date range to display?
I'm fairly new to QlikView and finally have my data sources set up properly so just trying to optimize the interface. Thanks for any help!
If you're using QV11 you can use alternate states. You can create these on the General tab of the Document Properties window. After you created them you can assing them to the sheets on the General tab of the Sheet properties window. And if necessary you can assign alternate states to individual objects like charts and listboxes too.
There are no built-in filters for last 24 Hours, last month, last year etc. It's possible to create something like that using an inline table and variables and triggers.
For specifying a date range you can use calendar objects. See here for a tutorial on that subject.
If you're using QV11 you can use alternate states. You can create these on the General tab of the Document Properties window. After you created them you can assing them to the sheets on the General tab of the Sheet properties window. And if necessary you can assign alternate states to individual objects like charts and listboxes too.
There are no built-in filters for last 24 Hours, last month, last year etc. It's possible to create something like that using an inline table and variables and triggers.
For specifying a date range you can use calendar objects. See here for a tutorial on that subject.
