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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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