hi,
Lets cover basics as I think you are missing few important details... when you say:
in chart i have used dimension Like Category and Measure i have used pick(wildmatch(Category, 'Value1','Value2',Value3'), $(vTotal),$(vSales),$(vProfit)).
So you have created Qlik Sense chart/table object which has
- dimension colum: Category
- measure column: which evaluates expression based on your dimension pick(wildmatch(Category, 'Value1','Value2',Value3'), $(vTotal),$(vSales),$(vProfit))
Based on the Category value then variable value is comming.
I can only partially agree to that waht you are saying as what happens is your chart dimension is taken into account when evaluating your measure expression and depending on dimension value expression is calculated. Since you are using in your expression $() sign expansion for your variables those effectively become part of your whole measure expression
if you want to transfer this whole chart hypercube to NPrinting you can add the chart object which has yourCategory dimension and measure expression in it to a NPrintign table node and then drag and drop it on to the template (for example excel). here you have an example:
https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ExcelReports/Create-Excel-Reports.ht...
On the other hand if you want to use Qlik variables directly in NPrinitng you need to know that they will basicly return evaluated single value (just like you would put your variable in Qlik Sense KPI object). You also need to understand that in order to do that your variable needs to be expanded in Qlik Sense meaning that its definition needs to start with "=" sign. I have already given you link regarding this in my previous post.
As an alternative you can use NPrinting formulas where you can call your variable (again same like in Qlik Sense KPI object where it will need to return single value). When using formulas you dont have to expand your variables in Qlik Sense as they can be expanded in NPrinitng formula directly.
I am assuming you are new to NPrinting, so I really suggest to go step by step through tutorials from help page starting from here where you can download working files: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Introduction/Get-started.htm and going through everything in getting started section of help page and Designing reports section. https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/QlikView-NPrintin...
This will allow you to build your understanding how NPrinting works.
When you say: Please suggest me how to take variables in Nprinting side. Is there any possibilty to take Qliksense variables in Nprinting designer. I cannot answer that question without whole context how you can use variables. You are using your variables in objects which has dimensions and measures/expressions... When we move that to nprinting we need to take this just like it is in Qlik Sense (meaning from the table/chart object) as columns for dimension and measure and not as individual parts of your measures which in your case are $(vTotal),$(vSales),$(vProfit)). Those can be individually brought in as variables or formulas (but then withouth Category dimension context).
regards
Lech
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
