Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

Hi ,

I am calculating a bar graph in QlikView which has a variable in the expression . Now when I will generate NPrinting report , I will have to be giving the value of this variable . Like

the expression for graph is defined as a variable say vMetric01. This metric contain another variable in the definition like

vMetric01= sum($(vVarSlice) Sales )

So when I create NPrinting report , I will provide the value for this vVarSlice variable. Will this work ( I am creating a bar graph on power point)

Please help , help !

1 Solution

Accepted Solutions

Re: Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

Its would be the set analysis expression variable rite ? you can it will work in NPrinting

7 Replies

Re: Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

vVarSlice variable will work in NPrinting , but do you need to calculate the sum in NPriting ??

I would not suggest to do that , better have all the calculation in Qlikview and then import it in NPrinting

Not applicable

Re: Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

yes , vVarslice need to be defined dynamically in NPrinting  and depending on the value of the vVarSlice , sum will be calculated in NPrinting.

Re: Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

Its would be the set analysis expression variable rite ? you can it will work in NPrinting

perumal_41
Valued Contributor II

Re: Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

Hi Jyoti,

I am assuming  you are using  NPrining 17 and NPrinting 17 variable filter can't pass .

But can achievable, by using Data island table .

1. Create island table and value changes in  vVarSlice ,load into island table

Load * Inline [

vID,vExpr

1,<Date={'$(MinDate)'}>

2,<CY={'IN'}>

];

2. =vExpr  use in vVarSlice variable.

3.Create filter Filter section   based on vID  and vExpr . if vID=1  filter then ,<Date={'$(MinDate)'}> assign  to variable vVarSlice.

4. pass filter in  NPrinting Desginer marked place.

I hope it solve your problem.

Regards,

Perumal A

pallavithota1
New Contributor II

Re: Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

Hi Avinash,

I saw so most of the answers are given by you in Qlikview and Qlik sense. Now am stuck with one issue with NPrinting using Qlik sense where i have added NPrinting On Demand button on Qliksense app and made connection too. Now when i try filter selection and export value then export button is not working. Can you share your suggestionss.

Regards,

Pallavi Thota

sourabh_t
New Contributor

Re: Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

Hi Pallavi,

We are also facing the same issue. After selecting the filter, export button is not working. Not sure, how it worked for qlik in YouTube video.

Thanks

Sourabh

pallavithota1
New Contributor II

Re: Passing value of varaible in Nprinting and evluating the expresssion containg that varaible

Thanks for your reply. If you get any solution do post here.

Community Browser