Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to NPrinting and Im trying to create an Excel report in NPrinting Designer and would like to have the data filtered differently for each tab. Dont know if there is that capability in NPrinting or I would have to try and create another table in the Qlik Sense App. Any advice is appreciated, thank you!
Tab 1 - All Records
Tab 2 - Records Greater than $2500
Yes its possible.
You will need to first create an Advanced Search Filter in NPrinting. (you must test your syntax in Qlik Sense to ensure it's accurate)
The syntax I used is:
=if(sum(Sales)>10000,sum(Sales),'Below Sales Target')
In the NPrinting Designer:
Results attached.
Kind regards...
Yes its possible.
You will need to first create an Advanced Search Filter in NPrinting. (you must test your syntax in Qlik Sense to ensure it's accurate)
The syntax I used is:
=if(sum(Sales)>10000,sum(Sales),'Below Sales Target')
In the NPrinting Designer:
Results attached.
Kind regards...
Here are the results when the formula is used in a Qlik Sense straight table.
Hi Frank,
Thank you for the reply! How do you create a copy of the table in NPrinting? and is there a way to not show the records that are tagged as 'Below Sales Target'?
You need to apply the filter to the object not the report. If you apply the filter to the report than both objects will be affected by the filter. You do not want that.
To get the result needed, you need to filter the object as I have already demonstrated.
1. How do you create a copy of the table in NPrinting?
Answer: right click on the 'tables' node to select a table. Do this twice. The second table with come with an _1.
2..and is there a way to not show the records that are tagged as 'Below Sales Target'?
Answer: yes. just replace 'Below Sales Target' with ' '
This is just a blank space to take the place of below sales target.
You taken on a more advanced topic for a new to NPrinting user.
I suggest you practice a bit and follow some of the free training found here.
Basic NPrinting template editing/design will all make sense very quickly in terms of using the NP designer.
But using formulas is a bit more complex and requires some Qlik Sense (or QlikView) experience so I tried to be as descriptive as possible for you.
Kind regards and hope it helps....