topic Re: Create pivot table on Nprinting pixel perfec in Qlik NPrinting

Create pivot table on Nprinting pixel perfec

c_pannese — Fri, 15 Nov 2024 22:48:14 GMT

Hi All,

is possible to create a pivot table in pixel perfect?

I've create straight table with data to use but i can't realize a pivot in pixel perfect.

thank you all.

Re: Create pivot table on Nprinting pixel perfec

Lech_Miszkiewicz — Thu, 17 Jun 2021 09:54:20 GMT

Hi,

There is no pivot table feature.

You can only mimic pivot table look by hiding showing cell values and borders around cells using straight table.

If you were thinking about adding dimension as a column - then this is not possible.

cheers

Re: Create pivot table on Nprinting pixel perfec

Dadiop — Mon, 19 Jul 2021 09:59:25 GMT

Hi,

As said by @Lech_Miszkiewicz you can only mimic pivot table look.

You can achieve that by creating a nested level in Pixel Perfect.

https://www.youtube.com/watch?v=kR9K04RFX8o

You can take a look at this video, it can be used as a "beginning template". With some custom (background color, borders, etc.) you should be able to do your own pivot table.

Depending on your application, you will maybe have to create calculated field for the subtotal and total (That was my case).

Here is just a little preview of my pivot table done on Pixel perfect (97% same as in QV)

It's not an easy work, but it's definitely possible. You can also use formatting rules in case you need to modify colors etc.