I have a report I am creating that gives a summary overview of profit and loss for my company. what i am trying to do is have 1 tab be the overall summary but the other tabs break down the summary by business unit. there are 2 business units I don't want tabs for. I tried to create a filter for those 2 units, but it also took the information out of the main summary report on the first tab. what can I do to be able to just get rid of those tabs only?
I did try to create a filter originally, however, when I put in the values, it filtered it in all pages, including the overall summary page, and we want to keep those values in the overall summary sheet, and then just exclude them from being split out into their own tab.
If it's fixed those values, try to filter at qlikview side using set analysis. duplicate sheets object for each business unit and overall tab in qlikview then u can call each chart object into qlikview nrpinting excel report.