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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview2018
Contributor
Contributor

Exclude the weekday filter in set analysis

I have a issue with a graph below. I want it when I select e.g. 10/08/2023 it should keep the figure for a Week and Month as it is.

 

Currently when I select a week day it shows the same figure for the Week and the Month instead e.g. 10/08/2023 (82,24%) , CW32-23 (81,75%) Aug-2023 (82,40%).

 

qlikview2018_0-1692257878879.png

 

 

 

qlikview2018_1-1692257878894.png

=(Count({$<[Day of the week]-={'Mon','Tue',’Wed’,’Thu’,’ Fri’,’ Sat’},[Date Filter Ranges] = {'Last 8 weeks'},[RW Debited Production Area No.]=, Technology =, [Debited CC]=,[Defect Place]=,[Defect Type]=,[Categories]=>}DISTINCT[F2 VIN])- Count({$<[Plant F2 Date]-=,[Date Filter Ranges] = {'Last 8 weeks'}>}DISTINCT[DPR F2 VINS NOK]))               /

                Count({$<[Day of the week]-={'Mon','Tue',’ Wed’,’Thu’,’ Fri’,’ Sat’},[Date Filter Ranges] = {'Last 8 weeks'},[RW Debited Production Area No.]=, Technology =, [Debited CC]=,[Defect Place]=,[Defect Type]=,[Categories]=>}DISTINCT[F2 VIN])

 

Labels (1)
1 Reply
pedrohenriqueperna
Creator III
Creator III

Hi,

 

Not sure if the expression provided is for one or every chart, but you could try to ignore filters by using $:: in set analysis (it tells Qlik to consider the default filter state), ex:

 

Sum({<Week = $::Week, Month= $::Month>} value)