topic Re: NPrinting - Specific Filter on Level or Calculated column with Table in Qlik NPrinting

NPrinting - Specific Filter on Level or Calculated column with Table

christiana — Fri, 02 Sep 2016 15:59:04 GMT

Dear all,

I'm currently struggling with one of my tables in Excel.

I wanted to create a table which has next to it a calculated column AND which has a specific filter which should not be applied to the other tables in the report.

As far as I know this is only possible with Levels but not with a "normal" table (my formulas always get moved down by the number of rows the table is inserting).

But it seems that I can't put a filter on a Level, at least this is not possible via the properties as in the table.

What can I do in order to have a table which has a calculated column and which has a specifi filter on?

Many thanks to you all,

Christiana

Re: NPrinting - Specific Filter on Level or Calculated column with Table

agomes1971 — Fri, 02 Sep 2016 16:32:42 GMT

Hi,

see this

How to Apply a Specific Filter to Tables or Images

HTH

André Gomes

Re: NPrinting - Specific Filter on Level or Calculated column with Table

christiana — Mon, 05 Sep 2016 08:07:39 GMT

Dear André,

many thanks for the link. Unfortunately - except if I missunderstand - this doesn't help to solve my problem.

The article explains how to put a specific filter on a Table. If I'm using a table I'm not able to add calculated columns - or is there a way how to do this?

The article doesn't explain how this is possible on Levels - or did I miss something?

Many thanks for your help / explication,

Christiana

Re: NPrinting - Specific Filter on Level or Calculated column with Table

Anonymous — Thu, 08 Sep 2016 19:58:07 GMT

Hi Christiana,

Could you please send a example of what you want to achieve?

Fernando V.

Re: NPrinting - Specific Filter on Level or Calculated column with Table

christiana — Fri, 09 Sep 2016 07:53:36 GMT

Hi Fernando,

of course:

This is the table I would like to achive:

I've created a table with levels in order to have to calculated columns (B and C).

Now I want to dublicate this table.

The first table should have a restriction on the MTD numbers and the second should have the restriction to show only yesterdays data.

I know that this is possible when creating a table:

But I'm searching for a way how this is possible via levels:

--> no possibility to filter via the properties.

Another solution would be a way how I could create a table with calculated columns.

So many thanks for your help and advise!

Christiana

Re: NPrinting - Specific Filter on Level or Calculated column with Table

Anonymous — Fri, 09 Sep 2016 19:26:23 GMT

Christiana,

See if this solution works for you.

if(Status=1,

sum({<MonthYear={'$(=date(monthstart(today()),'MM-YYYY'))'}>} Value),

sum({<MonthYear={'$(=date(addmonths(monthstart(today()),-1),'MM-YYYY'))'}>} Value)

)

I created a field named 'Status' and used it as my level in Nprinting. Each table created in NPrinting show a different expression.

Hope it helps.

Fernando V.

Re: NPrinting - Specific Filter on Level or Calculated column with Table

christiana — Fri, 30 Sep 2016 11:29:39 GMT

Dear Fernando,

sorry for my late reply! Could you please send me an example? I'm not sure if I got it correctly how to set it up.

Many thanks to you

Christiana