Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently sending out an exception report for multiple locations as an excel spreadsheet. The first sheet of the report is a list of all exceptions, and then the following sheets are by location. I would like the worksheets for each location to only generate if there are exceptions.
Example: There are three locations (A, B, and C) and here is a list of the exceptions:
Location | Model | Days On Hand |
A | Model1 | 30 |
A | Model1 | 45 |
C | Model1 | 30 |
C | Model1 | 40 |
I would like an excel report that has a 'Master List' worksheet that includes all exceptions to be sent, a worksheet for just location A, and a worksheet for just location C.
Right now, I am using the 'Page' selection to list the different locations per worksheet, but all locations are included, even if that location does not have any exception (B would be included in the example above). Is there a way to only have locations that have data, or exceptions, to be included?
Hi
I am not sure if it is the best way of achieving it, but i would check in Qlik load script for which combinations of location there is exception available and would create an extra flag field for such locations. Then i would use this flag as an initial filter.
regards
Lech