Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
mauvasco62
Contributor III
Contributor III

Filter in Qlik Sense to be used in NPrinting

Hi all,

i need your support in order to solve a little issue.

i'm making an app to be use with NPrinting

I created a master item called "New customers" 

the sintax is: count(distinct(if([Status customer ]='New',[_KCustomer])))

Besides i have 2 different dimensions

  • NPRINTING_FLAG_TEMP   --> to be use in Nprinting for generate the report
  • Branch --> to be use in Nprinting for generate the report related to specific users (i.e. if the user = Mario the related branch is Milan and the report in Nprinting will be related to data of Milan)

So now i need to create a specific master item that must not "feel" the branch filter.

The final results will be:

  • new customer of Milan
  • new customer of entire company

How can i do that?

Thanks a lot for your support

 

Mauro

1 Reply
mauvasco62
Contributor III
Contributor III
Author

...ops  NPRINTING_FLAG_TEMP is the period