Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%).
=(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])
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)