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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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)