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

[#1]

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 !

[avinashelite]

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

[#3]

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

[avinashelite · Accepted solution]

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

[perumal_41]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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