Hide the last two columns of a table based on the value in a field

[mstoler]

Hello,

I am using On Demand.

With NPrinting Pixel Perfect, I need to hide the last two columns of a table based on the value in a field.

In my Qlik Sense Dashboard when the user selected the prior year, I hide the last two columns in the table.

The problem is the Pixel Perfect report fails because when the user selects the prior year the columns are not visible.

1. It looks like NPrinting will fail if the columns are hidden and I use the table as a data source?  Is there a workaround?

2. If not what is the best way to handle this situation where sometimes the last two columns are hidden? I don't need to worry about gaps because these columns are at the end and are not relevant (they are YTD related) when prior years are selected.

Thank You,

Michael

[Lech_Miszkiewicz · Accepted solution]

Hi Michael

you know that NPrinting does not support hide/show columns in Qlik tables if it is used as a data so obviously you need a different solution  where columns will be always there (you need to have Qlik Sense object which will not be affected and will be supported in NPrinting) and you only hide or show those columns in NPrinting.

Now how you do it in NPrinting? I think the easiest would be applying conditional rule to the column like below:

thanks