Empty preview when Insert Table with Show Condition into PPT Nprinting

[Nin_04]

Hello Everyone,

I Need to add into NPrinting  ppt an Qlik Sense table with a show condition Columuns. When I try to load my Object table into Nprinting PPT my preview is empty.

How can i solve this problem or how i can apply an work around to obtain the same result  always hiding the columns?

Thanks in advance.

[Ruggero_Piccoli]

Hi,

First of all when posting new questions in the community please always add the label with the correct version you are using. The answer could depend on it. 

About supported and not supported objects refer to https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Qlik-objects-supp...

Instead of using a show column condition and importing the table by using the single table tag, import only the tags of the specific columns you want to use and remove the condition.

Best Regards,

Ruggero

[Nin_04 · Accepted solution]

Hi Ruggero,

thanks for your answer and  next time i will add  into the label my Nprinting Version,  anyway it's 22.15.2.0 .

The choose to apply the conditional column is that in my table  I have to show ten columuns with only last 10 days excluding Weekend days  and other 3 columns with the total MTD , MTD PY and the Delta. 

Unfortunately to obtain this structure (Attachment 1) and  build this solution i have create an table with one colum for each day  and if the day is Sat or Sun I don't show it. With your propose I don't know if  I upload all my table columns , I can directly manage  from NPrinting   the visibility condition for the weekend days.

Thanks in advance

[Lech_Miszkiewicz · Accepted solution]

Hi @Nin_04 

I dont understand where is the problem. Why dont you use set analysis in your expression to bring in only days you need to each of those columns. Obviously they need to be separate columns (each for each day and  MTD and MTD **bleep** etc. Each of those measures needs to be dynamic based on the selection and return only days you need in them. 

You dont have to hide anything if your expression is not bringing in data you dont need, right?

Once you do that you can just drag and drop each of those columns to table in NPrinting and underlying expression will populate data you need in it with required values.

The logic to "I have to show ten columns with only last 10 days excluding Weekend days " can be easily implemented in calendar or even directly in set analysis of each column so it skips weekends. It is not even NPrinting problem- you just need to write your expression for your measures correctly in Qlik Sense.