topic Re: New Calculated field Pixel Perfect in Qlik NPrinting

New Calculated field Pixel Perfect

ecabanas — Wed, 25 Nov 2015 12:40:38 GMT

My raw table coming from Qlik is:

OrderId Margin Ispositive

A 1 1

B 2 1

C -1 1

with this table I want to create a stack bar graphic to know the percentage the positive and negative orders, anyone knows how to create the Ispositive field? if(Margin <=0,0,1)

Many thank's

Eduard

Re: New Calculated field Pixel Perfect

Wed, 25 Nov 2015 12:48:36 GMT

question - do you not want the stcked bar chart within the QlikView application? Alos is there a specific reason you are using PixelPerfect for a bar chart? There are other tempaltes that are a little easier to use for simple objects like bar charts, and you can use table data in excel to create bar charts within the nprinting template

Re: New Calculated field Pixel Perfect

Mark_Little — Wed, 25 Nov 2015 12:49:31 GMT

Hi,

Could you please give some more details as you seem to have answered your own question.

Just add to you load script.

Load

if(Margin <=0,0,1) AS Ispositive

Mark

Re: New Calculated field Pixel Perfect

Wed, 25 Nov 2015 12:54:19 GMT

as mark said, it looks like you answered your own question regarding as far as the logic needed in a load script

but how does that question apply to an NPrinting pixelperfect?

Re: New Calculated field Pixel Perfect

ecabanas — Wed, 25 Nov 2015 12:57:51 GMT

Hi Adam,

Ok, Let's change and do it in Excel, how could I do this calculation for each row?

Many thank's

Eduard

Re: New Calculated field Pixel Perfect

buzzy996 — Wed, 25 Nov 2015 13:03:30 GMT

are u looking for this?

Re: New Calculated field Pixel Perfect

Wed, 25 Nov 2015 13:10:14 GMT

nprinting is used to take objects from qlikview and use them (or the data from the objects) to crate reports and then have then distributed. When using excel for example, you would use excel calculations to total columns or crate new columns from exisint columns.

I am not sure why you are wanting to do expression like detail withing nprinting - it should be in the load or expression and then nprinting would use the object?

Am I missing something?

Re: New Calculated field Pixel Perfect

ecabanas — Wed, 25 Nov 2015 14:04:52 GMT

Hi shiva,

the problem is that Margin is a looooong expresion in a set analysis, I tried to do an if in this calculation and did not work