Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

5 Replies
Highlighted
Creator III
Creator III

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

Highlighted
Not applicable

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

Highlighted
Creator III
Creator III

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

Highlighted
Not applicable

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

Highlighted
Creator III
Creator III

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