topic Re: Getting overlapping the images in Nprinting in Qlik NPrinting

Getting overlapping the images in Nprinting

Thu, 05 Jan 2017 08:04:47 GMT

Hi Guys,

I am using three diffrent colour arrows (Red,Green,Blue) & set three different rules for each arrows. But in Report PDF the arrows are showing overlapping in the "Change Column where as in the other "Change" column it is coming perfectly ok.

Please refer to the Image:

The Rule set for these arrows below:

Blue:

Iif([Value of Reclaims Outstanding TP] =[ Value of Reclaims Outstanding LP ] ,
[Value of Reclaims Outstanding TP]=[ Value of Reclaims Outstanding LP]
,[Value of Reclaims Outstanding TP]!=[ Value of Reclaims Outstanding LP] )

Green:

Iif([Value of Reclaims Outstanding TP] <[ Value of Reclaims Outstanding LP ] ,
[Value of Reclaims Outstanding TP]<[ Value of Reclaims Outstanding LP]
,[Value of Reclaims Outstanding TP]!=[ Value of Reclaims Outstanding LP] )

Red:

Iif([Value of Reclaims Outstanding TP] >[ Value of Reclaims Outstanding LP ] ,
[Value of Reclaims Outstanding TP]>[ Value of Reclaims Outstanding LP]
,[Value of Reclaims Outstanding TP]!=[ Value of Reclaims Outstanding LP] )

As you can see, the "This Period" & 'Last Period" value is coming same , it should come as Blue Arrow, but it is coming as overlapped.

Please help me to resolve the issue.

Thanks,

Iman Mukhopadhyay

Re: Getting overlapping the images in Nprinting

mkelemen — Thu, 05 Jan 2017 09:02:48 GMT

Hi,

where exactly is the formula placed? Iif() suggests Visual Basic...

It is quite hard to read with all the spaces at the beginning and at the end of field names. Is [ Value of Reclaims Outstanding LP ] different field from [ Value of Reclaims Outstanding LP] ?

BR,

Matus

Re: Getting overlapping the images in Nprinting

Thu, 05 Jan 2017 09:29:16 GMT

Hi Matus,

The formula placed on Formatting Rule Sheet Editor in Nprinting.

Space is not an issue as same condition applied on other field & the Arrow is coming correctly.

I have changed the "Spaces" but still getting the same issue.

Thanks,

Iman Mukhopadhyay

Re: Getting overlapping the images in Nprinting

mkelemen — Thu, 05 Jan 2017 10:24:08 GMT

I am not expert on PixelPerfect but just by looking at these formulas they seem odd...

I created a teble in QV and the result is that Blue is always TRUE, Green+Red are TRUE if TP!=LP.

Can you post the other formulas that work?

Matus

Re: Getting overlapping the images in Nprinting

Thu, 05 Jan 2017 10:34:33 GMT

Hi Matus,

Thanks for the information. You are correct. There was space/junk character at the end.Now it is coming perfectly.

Thanks,

Iman Muhopadhyay

Re: Getting overlapping the images in Nprinting

mkelemen — Thu, 05 Jan 2017 10:38:57 GMT

I still think these formulas are wrong and it is just working for TP=LP.

You should test some cases where TP>LP and TP<LP.

BR,

Matus