topic Re: Print to pdf only those whose values are not null in QlikView

Print to pdf only those whose values are not null

saumyashah90 — Tue, 24 Feb 2015 08:33:38 GMT

I have Report which consist of 3 charts and all are straight table

1)Employee Id ,Name,Number ,etc.

2)Field A, Field B ,Field C

3)Field D, Field E ,Field F

All these are columns.

Now in Report I have put banding on bases of "Employee Id" and there are 1000 Employees.

Requirement:

Now there are result in 2nd and 3rd chart where we don't have data for some employees. So I want report only for those whose data and details are present.

What is happening now:

Report is getting generated for Employees who data is not present keeping everything blank in chart.Which I don't want

Can any one help?

Re: Print to pdf only those whose values are not null

datanibbler — Tue, 24 Feb 2015 08:46:12 GMT

Hi Saumya,

there are checkboxes in the dialog on the "formula" and "presentation" tabs to suppress NULL values. Does that help?

Best regards,

DataNibbler

Re: Print to pdf only those whose values are not null

saumyashah90 — Tue, 24 Feb 2015 12:17:07 GMT

No that actually doesn't help.

That will affect Charts in qlikview.

But while Reporting when you select a field in banding it takes it from back end

Re: Print to pdf only those whose values are not null

Tue, 24 Feb 2015 13:20:56 GMT

Hi Saumya,

are you generating these PDF via publisher? or simple from within the QVW itself and saving the resulting report to PDF?

If within the QVW itself, there is an option on the report to adjust the initial selection in addition to doing the banding. So you could think about creating a bookmark which selects down and reduces the possible values within Employee Id so that only those with data remain (or make this selection manually before running the report).

The other option is to maybe create a new field in your load script, which performs some logic checks on your data and only populates those Employee Id's where there is possible data. This option would only be good for a fixed report though. Banding could then be done on this field.

Hope that helps

Joe

Re: Print to pdf only those whose values are not null

saumyashah90 — Tue, 24 Feb 2015 13:50:49 GMT

Within the QVW. Dragged the objects in to report required and on click saving it into a PDF.

Will look into you point and let you know