topic Re: How can I use Vlookup in Nprinting in Qlik NPrinting

How can I use Vlookup in Nprinting

lior_malcka — Wed, 24 Feb 2016 09:28:29 GMT

Hello,

I am trying to use the vlookup function on a report that im building with no success,

I used it like this:

<level>

data id

data

=vlookup(data id, return a value from a diffrent sheet with another level)

</level>

Hope I manged to make my self clear..

I understand why the Vlookup doesn't work, but i can't think of a way to make it work,

If someone have a nice solution for this problem i will be thankful.

or even just send me short explanation about how to use the Vlookup in Nprinting

thanks.

Re: How can I use Vlookup in Nprinting

Daniel_Jenkins — Thu, 25 Feb 2016 06:50:47 GMT

Hi Lior,

Lets say you have this table in QlikView.

Here Rating is S for Amount < 1000, M for Amount >= 1000 AND Amount < 2000 & L for Amount > 2000.

In QlikView NPrinting you want to use VLOOKUP in an Excel report to populate another column VL Val where S = BAD, M = AVERAGE & L = GOOD

You can use the Table in the level and use the VLOOKUP function in a new column. The above table is called DATA and sits on a different sheet.

Final report:

I have attached the project. Extract to folder C:\Temp\Community\040 or change the paths in the NSQ.

HTH - Daniel.

Re: How can I use Vlookup in Nprinting

Anonymous — Thu, 25 Feb 2016 15:53:19 GMT

While I see Daniels response as a way to solve the problem, I am curious on why you need to do this. It would be pretty easy to add a simple reference table to your data model in QV and have it just add this associated column to you table or chart. Even if you told me you were using aggregated data from two different sources, I would still pursue building the desired output in a chart in Qlikview before sending it to Nprinting.

Perhaps you can share what you are trying to do in more detail.

Re: How can I use Vlookup in Nprinting

lior_malcka — Sun, 28 Feb 2016 09:40:58 GMT

Thank for the explanation but it's not exactly what i meant, I have a sheet with page on customers (Meaning it's automatically opens a new sheet for each customer, I also make some calculation on each sheet) the Vlookup takes the calculated data from each customers sheet and create a new table :

cust1 ; calc fields from sheet of cust 1

cust2 ; calc fields from sheet of cust 2

...

the problem is creating the dynamic reference of the Vlookup to each separate sheet (because I create the sheets with the page function)

Re: How can I use Vlookup in Nprinting

Daniel_Jenkins — Mon, 29 Feb 2016 03:27:47 GMT

Hi Lior,

It will save a lot of effort and guesswork if you post a sample QVW and a mockup report of what you expect as the output. Someone may have a solution or a suggestion of an alternate way to achieve what you want.

- Daniel.