topic Re: NPrinting conditional row based export in Qlik NPrinting

NPrinting conditional row based export

patroser — Fri, 26 Jun 2015 10:56:08 GMT

Hi there!

I hope my concern is in place in the community. I had a look at vizubis community and couldn't find a Q&A part in the community.

I just had a meeting concerning NPrinting. The client hat a question concerning the conditions.

Unfortunately I didn't find anything about this topic, so I thought I'd ask in the community.

In case there already are posts concerning this topic, but I didn't find them, I'm sorry for bothering.

Let's assume we've got the following Chart in QlikView:

Client	Order	marginal return in %
Client A	112545	12
Client A	124513	15
Client B	123465	-7
Client C	124579	5
Client D	649745	-12

Is there a chance to create a report containing just the rows with a negative marginal return?

My other question ist about zero values in rows.

Let's assume we've got the following Chart in QlikView:

Client	Article	Amount 2015	Amount 2014	Value 2015	Value 2014
Client A	4545	12	17	100	120
Client A	7845	0	10	0	50
Client B	1245	7	15	45	90
Client C	1546	10	15	45	60
Client D	7845	0	45	0	90
Client E	8789	0	13	0	47

Exporting this Chart with NPrinting, but just displayin the current year ends up in some zero values in this report:

Client	Article	Amount 2015	Value 2015
Client A	4545	12	100
Client A	7845	0	0
Client B	1245	7	45
Client C	1546	10	45
Client D	7845	0	0
Client E	8789	0	0

Is there a chance exporting this chart via NPrinting dissregarding rows with zero values after not displaying all columns?

Thanks in advance!

Patrick

Re: NPrinting conditional row based export

Daniel_Jenkins — Sat, 27 Jun 2015 02:05:24 GMT

Hi Patrik,

You can create and use NPrinting field filters to achieve this. NPrinting supports Advanced Search like filters.

I have attached a small project that does what you want. Please extract to folder C:\Temp\Community\003\ in order to preserve the paths used or you will need to change the paths for the connection and report templates within the NPrinting project.

These are the filters I created:

HTH - Daniel.

Re: NPrinting conditional row based export

patroser — Sat, 27 Jun 2015 08:18:57 GMT

Great!

Thank you very much!

Patrick

Re: NPrinting conditional row based export

patroser — Sat, 27 Jun 2015 08:28:27 GMT

I'm afraid there is one more thing.

In reality those values are no dimensions, but expressions.

I just found a way to filter dimensions, is there a way to filter those expressed values?

Thanks in advance,

Patrick

Re: NPrinting conditional row based export

Daniel_Jenkins — Mon, 29 Jun 2015 03:34:43 GMT

Hi Patrik,

I have added a chart with expressions and filtered on one of them. Please see attached.

You can also filter on QlikView bookmarks.

HTH - Daniel.

Re: NPrinting conditional row based export

patroser — Thu, 02 Jul 2015 11:23:00 GMT

Sorry for my late response,

I'm testing your solution right now, but there seems to be a problem adepting it to my application.

But for now: Am I getting it right, that the person building the reports would need to have knowledge of the expressions of a specific chart to take advance of the filters for reducing the data as mentioned?

I'll let you know as soon as I know more about my having problems adepting the filter.

I thought using the expression would dolve the problem.

Assuming "Expression1" is my Expression calculating the relative profit, I used the following filter for just displaying the negative profit:

=if(Expression1 < 0, Expression1)

This takes ages to calculate and in the end i have a result showing other values than my chart in QV, also it still shows positive profit.

But I'll try little bit more and write again as soon as I know more.