Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

level functionality in table object excel template

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

4 Replies

Re: level functionality in table object excel template

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

ogster1974
Honored Contributor II

Re: level functionality in table object excel template

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

lech_miszkiewic
Honored Contributor III

Re: level functionality in table object excel template

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

sureshqv
Esteemed Contributor III

Re: level functionality in table object excel template

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

Community Browser