level functionality in table object excel template - Qlik Community

Report Inappropriate Content · ‎2017-04-16

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

Anil_Babu_Samineni · ‎2017-04-16

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

ogster1974 · ‎2017-04-16

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_Miszkiewicz · ‎2017-04-17

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

Chanty4u · ‎2017-04-18

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