Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to pass dynamic values of From date and To date from Qlik sense app to N printing report which is not happening even though i have defined variables in N printing report which point to corresponding date field in Qlik sense app What is the expected result? The From date and To date selected in on demand Qlik sense app should pass values to N printing report and the report available on newsstand should display values based on
Hi Mate,
I have already provided a solution to how it can work, so please search community before posting duplicated topic. In short - you cannot use variables to pass your selections (you need to use fields instead).
Hi Leech
Thanks for your response
I went through all discussions and tried my best to achieve the result but unfortunately no success so far.
Below are the things i tried
My N Printing version is June 2019
My Qlik sense version is 2019
N print designer is Jun 2019
I have from date and to date numeric fields created in my Qlik sense application i have also created two variables in my Qlik sense application.
I have assigned values to variables by passing the date fields.
I have also created variables in N print reports and assigned them to date field values from qlik sense application.
I tried all possible ways
In N printing filter i used option
1.Evaluate=num(vFromdate)
Evaluate=num(vToDate))
Alternately i tried Evaluate ='num($(vFromDate))'
Evaluate='num($(vToDate))'
Hard coded numeric value this option works
Numeric value 3126
Numeric Value 3300
Can you please help me where i am going wrong.
Regards
Arvind
I replied to the same in other post:
Mate,
I have no idea what you are trying to do. I have seen your post in other thread and i responded to it.
now - to help you more please answer following questions:
...I have from date and to date numeric fields created in my Qlik sense application i have also created two variables in my Qlik sense application. - What do you use it for - how do you want to interact with it in Qlik Sense?
I have assigned values to varibales by passing the date fields - What do you mean? Can you share script/expression/formulas?
...I have also created varibales in N print reports and assigned them to date field values from qlik sense application. - You cannot create variables in NPrinting - you can only use variables from Qlik Sense/QlikView and show their evaluated in Qlik values (the will not evaluate in NPrinting!!! - expcept from where they are used to build a formulas in for example excel template)
Now what do you do in NPrinting?
you are saying....
In N printing filter i used option
1.Evaluate=num(vFromdate)
Evaluate=num(vToDate))
Alternately i tried Evaluate ='num($(vFromDate))'
Evaluate='num($(vToDate))'
Hard coded numeric value this option works
Numeric value 3126
Numeric Value 3300
So what is the field you are trying to filter?
Why would you use variable to do it especially that you have no control over this variable in NPrinitng except if you apply filter on the field (which you do by applying numbers like 3126,3300...)
I suggest you spend some time writing a well described question with steps, scripts screenshots of what you are trying to do and what would be the expected output. I think your current solution will never work as my gutfeel tells me that you want to filter field by variable value which gets evaluated based on the same field value (kind of circular reference which would not make any sense).