Qlik Community

Member Articles

This forum is for user/member-created articles across the entire Qlik portfolio. Any member that is logged in can create and publish an article here. You must choose the appropriate label in order for the articles to be properly categorized.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE

Pixel Perfect - Striped Table

cancel
Showing results for 
Search instead for 
Did you mean: 
vitaliichupryna
Creator III
Creator III

Pixel Perfect - Striped Table

Hi,

In this article  I will describe the steps which allow you to create striped table in the PixelPerfect report.

1. Create a straight table in the QlikSense, e.g.  Population table

2. Add expression as a last column:

Even(Row(Total))

Row(Total) adds number to each row, even function shows if the number is even or not.

Straight table1.jpg

3. Add Table as a level in the Nprinting report

AddLevel.jpg

4. Create a table

  • Add Group Header and change background to preferred color, for instance 91; 155; 213
  • Change Font color to white
  • Add all columns from table into Detail
  • Apply necessary formatting
  • Reduce the size of Even column to 10 and change its font color to Transparent. Even column should be hidden from user, we will use it only in the formatting condition
  • Reduce the size of "Population" column  by 10. After this all the visible columns will look the same in the report.

Report.jpg

5. Create a formatting rule with the following settings:

Condition:

Iif([Even(RowNo(Total))]  == -1,  True, False)

Background Color: for instance 221; 235; 247

 

Condition.jpg

6. Apply formatting rule to the level

Add Formatting Rule.jpg 

7. Generate the report

ReportExample.jpg

Hopefully  it will be useful.

Thanks,

Vitalii

Version history
Last update:
‎2020-05-11 06:02 AM
Updated by:
Contributors