There is a possibility that your source data is 'textual' rather than 'numeric'. In which case I would suggest setting the document property field settings to the default 'mixed' rather than 'integer'.
Also, if you select 1,000,000 from your Unit list box in your QVW, does the data model allow this selection update the chart output in your QVW as expected. Do the charts change when you make this selection?
In any case, try make copy of the QVW, perform the change above, create a separate connection to this copy QVW and create a simple report in NPrinting.
Assuming that the source data in the 'unit' field could be textual, you should also use 'value is' as the value type in your NPrintng filters with respect to this field.
So basically 2 things to look into:
- 1. is the data model ok: is the unit field linked to the fact table in the data model
- 2. the possibility of textual rather than numeric data in the 'unit' field.
Hope this helps...if not perhaps others here may be able to assist.
Please remember hit the 'Like' button and make helpful answers as 'Solution Accepted'... Cheers!