Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a summary sheet with 9 charts. The first 3 relate to mileage, next 3 sicness and lasst 3 leavers.
The data comes from different excel sheets, each of which have a fiscal year identified (2013/14, 2014/15). So we have a 'fiscal year' mileage that is on the mileage data, a 'fiscal year sickness' that is on the sickness data, and so we have a 'fiscal year leavers' that is on the leavers data.
Assume one option would be to transfer all the sheets over to a master sheet so year appears once; however, this is a lot of work so is there a way to tell Qlikview when one of these year filters is selcted (e.g selecting 2014/15 on fiscal year mileage) it only updates the corresponding 3 mileage charts (as apposed to all relative like a traditional filter would do)?
Chris
If you DON'T want one fiscal year filter (or a filter from any field for that matter) to influence a specific chart, use SET ANALYSIS on all chart expressions as follows:
An existing expression like this :
Sum(Sales)
Would be updated as follows to disregard any user selection in the field: FiscalYearMileage
sum( {$<FiscalYearMileage=>} Sales)
For multiple, like FiscalYearMileage and FiscalYearSickness , just use a comma as follows:
sum( {$<FiscalYearMileage=,FiscalYearSickness=>} Sales)
The $ means to listen to all user selections the <> section lists adjustoments to specific field filters .