clever filter

Fri, 28 Nov 2014 16:51:56 GMT

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

Re: clever filter

JonnyPoole — Fri, 28 Nov 2014 18:13:02 GMT

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 .

topic Re: clever filter in QlikView

clever filter

Re: clever filter