If Condition calculation in Group Footer for NPrinting 16

[nandraja]

Hi All,

I am developing pixcel perfect report in Nprinting 16 version, in that i want to write if condition on basis of count of Portfolio Name is greater than 1 then it should print 'Students' and if count =1 then print 'Sudent'.  

Subject                      Student Name

Physics                                   A

Physics                                   B

Physics                                   C

Physics                                   D

Chemisty                               F

Chemisty                               E

Chemisty                               G

Chemisty                               H

Chemisty                                I

Chemisty                               J

Output of the Nprinting Report:- 

Subject                       Student Name

Physics                                   A

                                         1 Student

Chemisty                               B

Chemisty                               C

Chemisty                               D

Chemisty                               E

Chemisty                                F

Chemisty                               G

                                         6 Students

[nandraja]

Hi,

Thanks for helping me. But i am very new to qlik nprinting. Can you send me your demo .nsq file, so that i can apply the same logic in my report. It's urgent.

Thanks in advance,

Rajeev 

[Ruggero_Piccoli]

Hi,

Two very important information:

• Qlik NPrinting (and QlikView NPrinting too) is an Enterprise class software with many features. You must be trained before starting to use it, you cannot just sit down in front of Qlik NPrinting Designer and be able to create sophisticated reports. Please, start by studying the official help site https://help.qlik.com/en-US/nprinting/November2019/Content/NPrinting/Introduction/Introduction.htm. The help site has also training videos and working examples and a complete chapter about PixelPerfect.
• This is a community of volunteers without any warranted service level agreement. If you need urgent support you need to open a support ticket. Here people share their knowledge and time for free. 

1. Drag and drop two labels from the left side tool Box.
2. Set Visible = No on both Property Grid.
3. Type the singular string (student) into the first label
4. Apply the formatting rule that made the singular label visible as explained in the tutorial
5. Type the plural string (students) into the second label
6. Apply the formatting rule that made the plural label visible when count()>1 as explained in the tutorial
7. Overlap the cells so they will be printed in the same position in both cases

I tested this solution and it worked in Excel and PDF.

Best Regards,

Ruggero