Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

daveatkins
New Contributor II

how to create excel report with 3 columns/tables

I need to produce a report that has 3 columns listing items that have been bucketed into those columns. The data is a list of items that can be grouped into a status of red/yellow/green and the goal is to have those be 3 separate lists across the page:

Red     Yellow     Green

1.         1.               1.

2.          2.               2.

               3.               3.

               4.

now the data would naturally sort as

red

red

yellow

yellow

yellow

yellow

green

green

green

but that is not the desired format

and this data is grouped so it all wrapped in pages and sections

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Honored Contributor III

Re: how to create excel report with 3 columns/tables

Simply upgrade to latest version of NPrinting - it supports object filtering (table as well). Just remember to create your filters first in filters  menu of nprinting console.

1.png

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
8 Replies
daveatkins
New Contributor II

Re: how to create excel report with 3 columns/tables

I thought there was some way to filter the tables, but a filter on a table object from QlikSense is not supported and I cannot figure out how to create 3 tables in QlikSense that are pre-filtered other than by making every dimension conditional on the filter criteria.

Lech_Miszkiewicz
Honored Contributor III

Re: how to create excel report with 3 columns/tables

Simply upgrade to latest version of NPrinting - it supports object filtering (table as well). Just remember to create your filters first in filters  menu of nprinting console.

1.png

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
qliksus
Valued Contributor

Re: how to create excel report with 3 columns/tables

Are you looking for something like a Generic load

The Generic Load

daveatkins
New Contributor II

Re: how to create excel report with 3 columns/tables

I have the following Nprinting version which does not include this feature as far as I can tell...

Qlik NPrinting June 2017

Version: 17.4.0000.0

Lech_Miszkiewicz
Honored Contributor III

Re: how to create excel report with 3 columns/tables

The latest is September 2017 (17.5)


Regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
daveatkins
New Contributor II

Re: how to create excel report with 3 columns/tables

are you saying this support was just added in 17.5? I just don't want to waste time going through the upgrade if the feature is not present. I already tried to follow instructions like this but then found that the filters were only supported in QlikView objects, not QlikSense objects.

daveatkins
New Contributor II

Re: how to create excel report with 3 columns/tables

answering my own question from the release notes:

Object filters for Qlik Sense charts

Jira issue ID: OP-5385

You can add object level filters also to Qlik Sense charts. Previously you could only add filters to

QlikView charts. You can still add only one filter for each chart.

Lech_Miszkiewicz
Honored Contributor III

Re: how to create excel report with 3 columns/tables

Keep in mind that one filter can contain multiple fields filtering in it as one filter is a single NPrinting entity which allows you to put multiple fields and filter all of them according to your needs.

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser