topic Re: Create table from list in word template in Qlik NPrinting

Create table from list in word template

adrianfer — Mon, 31 Aug 2020 06:18:42 GMT

Hello, just trying to find out if it is possible to create a table from a value list?

For example, I have a field named 'Alphabet' with values A,B,C,D....O

I want to display that in Nprinting (word doc) in a table with 5 columns, like so:

A	D	G	J	M
B	E	H	K	N
C	F	I	L	O

How can this be achieved, if at all possible?

Thanks for the help as always.

Re: Create table from list in word template

Lech_Miszkiewicz — Mon, 31 Aug 2020 08:34:06 GMT

It is not really nprinting question - isn't it? For NPrinting you first need to build the same in QlikSense.

I can imagine such solution to be built based on rank function where for 1st column you would have rank of 1,6,12,18 etc... for second column rank of 2,7,14... etc

Then you would use this table as a source in your word document.

To give you more precise answer we would need to get specific requirements.

Re: Create table from list in word template

adrianfer — Mon, 31 Aug 2020 22:27:27 GMT

You are absolutely right. And that gave me an idea about how to tackle this.

Thank you.

Re: Create table from list in word template

Lech_Miszkiewicz — Mon, 31 Aug 2020 22:49:28 GMT

great - glad I could help.