Filtering Specifc Sites

[rduah4u]

I have a kiosk report that reports on statues for kiosks per site daily for the rolling 7 days. I created a Variable that $(vFlagYCount) that =Count(Distinct(Kiosk_No) - this is shown as 13 under the flag tab. The sites listed are ones that show a status of Kiosks where there has been an offline status in the last 7 rolling day period. This is already defined in my report via calculated dimensions/measures. Therefore the sites that appear in a specific only has sites that have an offline status which is what is needed. The app also has sheets for other purposes that include all sites. However, focusing on this sheet, i only want emails sent to sites with a Kiosk Status 'offline' for the previous days to appear on this report regardless if they are on the other sheets. At the moment it's sending emails to all sites and where sites have been ok all week its replacing the status with 'Offline' which is not true and sending them emails to show this. I already have an import list that im using for my distibutions and im just currently testing the sites that shouldnt have emails sent to them, but this is not working. 

[JandreKillianRIC]

Hi @rduah4u 

I would add a flag / filter in the back end. This might require some data modelling but only have the kiosks that has been offline for 7 days or more in a table. Linking to the main data with a kiosk key / kiosk name and a flag. For example "7days offline" with the values 1 or 0. 

On NPrinting just selecting the 1 on this flag for this report should solve your issue. 

Regards - Jandre

[Lech_Miszkiewicz]

Hi @JandreKillianRIC 

You have described situation vaguely without any context. It is like saying: it does not work, why?

• To send reports to only specific sites you would need to enable REPORT condition and you would need to have recipients (which represent sites) with respective site as a filter
  • once condition is evalueated for the site  (CONDITION on REPORT not on the TASK) you either get report produced or not
  • the next thing is handling of errors - since for some sites you will not have report produced you will need to make sure your settings are set so that reports which are not produced are also not send: https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/AdministeringQVNprinting/Admin-... 
• One thing you mention is that other sheets have all sites and this sheet has only actual offline sites - how do you achieve that?
  • are you using sheet triggers to apply selections? - Those will not work in NPrinting and you would need to create filter recreating sheet action behaviour
• How do you populate "Offline" - from screenshot it looks like a measure hence it isn;t really something you can filter by
• You mentioned things about calculated dimensions - those depending on context may not work properly
• depending on actual settings in properties pane of the object you are using in Qlik Sense you may want to disable "show null values" on dimensions!
• If we knew what you need to filter (I assue filter needs to be applied on site/kiosk) dimension we could suggest how to use advanced search filter to do that.

@rduah4u suggestion is also good and simplifies things if they get too complicated

I dont want to comment more as we have to know exactly how we drive report generation before we can actually answer that question.

cheers

[David_Friend]

@rduah4u also what version of NP and QS will help!