Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

rieskamp
New Contributor

How to eliminate 0 value columns in NP excel level reports?

Hi all,

how can we eliminate 0 value columns in NP excel level reports.

E.g. we want to create something like this on the right side:

The columns with 0-values (depending on level !)  should be removed.

Is there any idea?

Thanks a lot.

Regards Michael

2 Replies
Highlighted
tomasz_tru
Valued Contributor

Re: How to eliminate 0 value columns in NP excel level reports?

Add a condition to the load script:

WHERE len(Monat)>0

and try: Remove Empty columns (All Null values) in script dynamically

You don't need to have summaries - Qlik is good at calculating them

BTW. If it's possible try to load clean data.

rieskamp
New Contributor

Re: How to eliminate 0 value columns in NP excel level reports?

Hi Tomasz,

the link is very interesting, I can use the script  otherwise very well, many thx.

The problem here is, that the columns of the table in total sum are not 0.

Depending on the level the column has a sum with 0-value at the level or not, e.g. column Umsatz_ST in the example above (0 for Proline128 and 42.236 for Start).

The Levels are build by NPrinting definition on base of a straight table out of QV.

I don't know how to "dynamically" eliminate the column at level.

Regards

Michael

Community Browser