Create N Printing Report using Qlik Sense table with Show column if

[Tami]

Hello,

We are trying to create a report in N printing that will show monthly  comparison to last year up to current month. For example in Feb we would show Jan and Feb. In April we would show Jan, Feb, March, April. We created a show column if statement to conditionally show the column if it is in current month.  As an example for April, we added this condition month(vYesterday)>=4.  Even though this report is built as a a table, we do not see the column options to build out our report. 

Please let us know how the show column if impacts the reporting in N Printing. We are on Qlik NPrinting November 2019 and plan to upgrade to latest version next week. 

There may be a better to way to build this report and are open to suggestions. 

[Lech_Miszkiewicz]

Hi @Tami 

This topic was discussed many times on community so I suggest you do some research as well.

In short "Show column if" is not supported. I wrote about it just yesterday here:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Columns-in-table-no-longer-available/td-p/1...

The workaround would be to put condition inside the expression like:

=If(month(vYesterday)>=4,Yourexpression, Null())

Then in the report you would have to bring in all columns in but only columns where condition is true will be populated.

THERE IS NO WAY YOU CAN CONDITIALLY HIDE SHOW COLUMNS IN NPRINTING (when trying to use the as individual columns)

cheers