Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
has3240
Contributor II
Contributor II

Set Anaylsis filter is changing based on Selection

Hi Everyone,

 

I am running into a strange issue. My MTD set analysis is working fine, but the moment I select a specific store somehow my set analysis is ignoring my MTD To filer. 

=num(Count({<Rental_Date = {">=$(=(MonthStart(Max(Rental_Date))))<=$(=Max(Rental_Date))"}>}Rental_Store),'##,##0')

Without Store Selection Filter

has3240_0-1625245006540.png

 

With Store Selection Filter

has3240_1-1625245047660.png

 

10 Replies
dgcustomermode
Contributor
Contributor

 


@has3240 wrote:

Hi Everyone,

 

I am running into a strange issue. My MTD set analysis is working fine, but the moment I select a specific store somehow my set analysis is ignoring my MTD To filer. 

=num(Count({<Rental_Date = {">=$(=(MonthStart(Max(Rental_Date))))<=$(=Max(Rental_Date))"}>}Rental_Store),'##,##0')

Without Store Selection Filter

has3240_0-1625245006540.png

 

With Store Selection Filter

has3240_1-1625245047660.png

 


I really like this, clean minimal, responsive just what i was looking for, cheers mate.  DGCustomerfirst Survey