Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

View solution in original post

7 Replies
Highlighted

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

Highlighted
Not applicable

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

Highlighted

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

View solution in original post

Highlighted
Partner
Partner

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

Highlighted
Contributor II
Contributor II

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

Highlighted
Contributor
Contributor

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

Highlighted
Contributor II
Contributor II

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