Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Getting overlapping the images in Nprinting

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:

Arrow.png

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

Tags (1)
5 Replies
mkelemen
Not applicable

Re: Getting overlapping the images in Nprinting

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

Not applicable

Re: Getting overlapping the images in Nprinting

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

mkelemen
Not applicable

Re: Getting overlapping the images in Nprinting

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

Not applicable

Re: Getting overlapping the images in Nprinting

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

mkelemen
Not applicable

Re: Getting overlapping the images in Nprinting

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

Community Browser