Banding - loop report over possible values in field
This banding feature is good but I have one issue. My "dimensional attribute" that I am "looping" over has members/rows that have no data for my current selection. This in itself is fine and "correct" but I dont want those dimensional members/rows printed on the report. In the properties of the table/chart that I have in my report i have:
1) under dimensions -> suppress value when is null and
2) under presenetation -> suppress zero value in all columns
The second option i suspect only works if there is zero values, for a row, in all measures but i have not tested it. Anyway, neither option suppresses banded rows that do not have associated data. Because i dont see these values in my table with current selections, I assumed the report would not print them either but such does not appear to be the case.
Rob, i added a qvw attachment to my previous post. It has one report. If you open the report and click "print preview" you will see the report. The first page that comes up is for a person I called NODATA. There are no transactions for this person but sadly the banding featture does not seem to respect the associative technology and filter out dimensional members that have no facts as does the table that this report is based on does. The Banding feature associated with the report is under report settings -> selections tab -> Banding)
Thanks Rob. That looks like it will work just fine. I guess i just thought that the associative "technology" would filter out those dimensional members that were not related to facts in the data context of the report. The "extra" dimensional members are related to facts but historical ones. So, in a current report, many of them will not be involved.
As it turns out I am using my current selections in the report. This reports is run by a macro and first activates a sheet that has a trigger setting the "date" conditions. If I use a bookmark, it will no longer set the correct date conditions. Boomarks and Current Selections are mutually exclusive options it would seem.
Tim Webber wrote: Boomarks and Current Selections are mutually exclusive options it would seem.
No. Set the "Make Bookmark Apply on top of Current Selections" property in the bookmark to make the bookmark additive. For an existing bookmark, it's the "+" column available from the Bookmarks -> More menu,
That works! Thanks. Never used an expression as a search condition. Pretty cool but my application is getting full of little gotcha's or rather bandaids!
This report is launched by a macro. My next challenge is to capture a darn error message. One of the filters i apply in the macro results in zero data - for now. So when i try and print the report Qlikveiw complains:
Caption reads: Empty Reprot
Body of dialogue box:
The report will not be printed
Error Message
No possible values for field <mytable.myfield> used for banding.
