I would like to create a nprinting task, which creates a file for each location which is in the source table. So not iterate through all locations, and create files with only a header in it for locations which aren't in the source table, but create no files for those locations at all.
Details: I've created a table within qlik sense, holding several records, which can be split accross different locations. In Nprinting, I would like to create a file for each location, holding the records for that specific location. However: Not all locations are in the table. There is a set expression in there (using the intersection "P" command), which only selects the locations on which there is at least 1 customer of a specific type. So, in week 1 there could be 2 locations, in week 2 there could be 4 locations. We'll never know in advance.
Any clue? I currently iterate through the locations, and tried to create a filter on the report, but I must include the locations by name in there. And that way my flexibility is gone...
Curious about your options! The only thing I can come up with is to introduce an extra flag in my app, which flags the locations which have customers this month. I can filter on the flag in nprinting. But maybe there's a standard checkbox which I'm overlooking, to not create any empty files.
Thanks for the reply! I'm not really sure if conditions are the best way to go. It's not that I want the report to conditionally be sent, but I want a report for each location, which is present in the source table of the report. So for example, if only 5 locations hold data out of 10, I only want 5 reports to be generated.
Unfortunately, this doesn't help either. I think I might need to explain my problem a little better.
I've got a table in Qlik, which limits the locations based on a set expression in the measure. For example: - I only show the revenue of locations - Of which there are customers of type x
So, the table holds only records which I would like to have in my final reports, but the app holds more locations which aren't relevant for my report.
In NPrinting, I need to export a file to a disk drive, for each of the locations which is in the table. I created a task which iterates through location, and creates a file for this location. But, when I iterate through the location field, all locations are used for the report: Also the ones which are not even in my source table.
If that isn't the solution then I might recommend speaking with your Qlik Account manager or a Qlik Partner who might assist you in performing a detailed needs analysis to explore this seemingly advanced development requirement.
We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!