topic Re: level functionality in table object excel template in Qlik NPrinting

level functionality in table object excel template

Sun, 16 Apr 2017 06:15:15 GMT

Hi,

I need to replicate excel function for each row using right() excel function to present part of another column value how can I do that with table object in excel template?

I know how to do it with level but I cant use filters on levels which i can with table in excel template.

Thanks,

Amko

Re: level functionality in table object excel template

Anil_Babu_Samineni — Sun, 16 Apr 2017 07:43:35 GMT

How is your values looking on that field. We have same environment like Subfield() to replicate and split into bulk fields from one long string / Binary

Re: level functionality in table object excel template

ogster1974 — Sun, 16 Apr 2017 08:41:26 GMT

Can you not do this in your table then bring it into nprinting directly?

They recommend you have a dedicated app for use with nprinting so you have tables and charts ready for use in nprinting.

Regards

Andy

Re: level functionality in table object excel template

Lech_Miszkiewicz — Tue, 18 Apr 2017 00:09:41 GMT

Expand table in Qlik and then bring it as a table.

Re: level functionality in table object excel template

Chanty4u — Tue, 18 Apr 2017 10:40:38 GMT

Hi,

first create a base sheet for your table

and create sheet2 with your filters and then like that how many filters you have you can create that many sheets

then after delete the data in base sheet and do refresh in excel and load that template