topic Re: Pivot table HTML code in Nprinting Nov 18 in Qlik NPrinting

Pivot table HTML code in Nprinting Nov 18

vikasdesai — Fri, 10 May 2019 10:17:09 GMT

There is a requirement from the business user that he need a pivot table in the email body which is automated from Nprinting (Nov 18)

Please note : I need pivot table code in HTML and don't want the image of the Qlik object in the email body.

Please help me with the solution .

Thanks and Regards

Vikas Desai

Re: Pivot table HTML code in Nprinting Nov 18

Lech_Miszkiewicz — Fri, 10 May 2019 11:04:15 GMT

great mate!

now:

provide us with version of software you are using + SR.
- QlikView or Qlik Sense - which version?
- NPrinting - which version (i see Nov 18, but i suggest to upgrade to April 2019)
screenshot of your pivot table in QlikView or Qlik Sense
screenshot of expected result
some additional info like:
- since it is a pivot table is the number of columns dynamic?
- if it is static maybe you could use straight table with set analysis an mimic pivot table behaviour
making html code for dynamic number of columns may not be possible - so do not get your hopes too high!!

once you give us above we maybe be able to give you some indication if what you are trying to do is achievable

looking forward to hear back from you

cheers

Re: Pivot table HTML code in Nprinting Nov 18

Lech_Miszkiewicz — Fri, 10 May 2019 11:06:23 GMT

as a side note - we cannot use any js script as it will not be executed in email body anyway.. so this task becomes quite challenging

Re: Pivot table HTML code in Nprinting Nov 18

Ruggero_Piccoli — Fri, 10 May 2019 13:35:53 GMT

Hi @vikasdesai ,

I agree with @Lech_Miszkiewicz .

You could also try to:

create the pivot table in the source document or app
create the connection and generate the cache as usual
add the pivot in the tables node of the HTML template
embed the HTML report in the email body

All details about the steps are documented in the official help site.

Best Regards,

Ruggero

Re: Pivot table HTML code in Nprinting Nov 18

SanthoshkN — Wed, 22 Jan 2020 16:28:39 GMT

Hi @Ruggero_Piccoli , I had similar requirement and I had created HTML report as per the steps, but the HTML report doesn't give the same pivot structure as in Qlikview desktop rather gives as excel export format.

Can you suggest for having the exact Pivot format in HTML email report.

Regards, SK

Re: Pivot table HTML code in Nprinting Nov 18

Lech_Miszkiewicz — Thu, 23 Jan 2020 05:51:21 GMT

Hi @SanthoshkN

You need to do a lot more to get a pivot table look in HTML table as each of the rows in your html table would need to have dedicated inline formatting. There is no wizzard nor drag-drop solution. You need to code it in HTML and to be precise there is a lot of work to get it right.

How does your table need to look like? Sample of your pivot table would help to understand granularity of it, number of dimensions used etc.. Once we have sample, we may be able to mock something up and give you more accurate answer.

Thanks

Lech

Re: Pivot table HTML code in Nprinting Nov 18

SanthoshkN — Thu, 23 Jan 2020 14:42:43 GMT

Hi @Lech_Miszkiewicz ,

Thanks for your response. Can you please share any sample you have to present HTML report for 3 dimensions with one dimension is pivoted and the HTML report should be exactly as same as pivot table we get in Qlikview desktop.

Hope am clear on my requirement.

Regards, SK

Re: Pivot table HTML code in Nprinting Nov 18

Ruggero_Piccoli — Thu, 23 Jan 2020 15:11:58 GMT

Hi,

HTML still is HTML also in Qlik NPrinting so you have its limitations. In Qlik NPrinting you can develop report templates in HTML that uses HTML features but it doesn't add new features to the HTML. So you have to use standard HTML features to create the report that you want.

Best Regards,

Ruggero

Re: Pivot table HTML code in Nprinting Nov 18

Lech_Miszkiewicz — Tue, 28 Jan 2020 03:38:29 GMT

Hi @SanthoshkN

Pivoted dimension would be very hard to do. I normally change it to straight table with set analysis mocking pivoted dimension

Then for dimension 1 & 2 I normally use row-span to create expression which i use in NPrinitng as a td tag in table which creates grouping on dimensional columns (see screenshot)

formula to create "pivot formula"column in Qlik app. This is very basic example to show you an idea on what can be achieved.

If(Dim1<>Above(Dim1),
'<td rowspan="'&RowSpanNo_1&'">'&Concat(DISTINCT Dim1)&'</td>
<td>'&Concat(DISTINCT Dim2)&'</td>
<td>'&exp_1&'</td>',
'<td>'&Concat(DISTINCT Dim2)&'</td>
<td>'&exp_1&'</td>')

screenshot:

Re: Pivot table HTML code in Nprinting Nov 18

Lech_Miszkiewicz — Wed, 29 Jan 2020 05:55:23 GMT

hi @SanthoshkN

one more question...

Pivoted dimension (the one which creates columns), how many distinct values do you expect to see in it on average?

I played little bit more with it and I think that i may have a solution for you as long as there is reasonable number of distinct values in pivoted dimension.

this is an example is result of what i came up with....I used QlikView but with Qlik Sense principles are the same

table no selections

result in nprinting

table selections applied

result in nprinting

Re: Pivot table HTML code in Nprinting Nov 18

SanthoshkN — Mon, 03 Feb 2020 18:18:55 GMT

Hi @Lech_Miszkiewicz ,

Thanks for the code. Will try to check if the similar code works for me and update you.

Regards,

SK.

Re: Pivot table HTML code in Nprinting Nov 18

Sid9 — Wed, 16 Mar 2022 13:12:52 GMT

Hi I have a query. What if the columns / dimensions of the table itself are not populating on nprinting? I am using Qliksense though. Have you faced such problems before

Re: Pivot table HTML code in Nprinting Nov 18

Lech_Miszkiewicz — Wed, 16 Mar 2022 13:30:01 GMT

Sorry @Sid9

i dont understand what do you mean? Can you elaborate?

keep in mind that the sample i have given you is using qlik sense straight table to produce final result as qlik sense pivot table are not supported with that configuration

Re: Pivot table HTML code in Nprinting Nov 18

Lech_Miszkiewicz — Thu, 17 Mar 2022 21:15:27 GMT

the whole walkthrough is here: https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/