9 Replies Latest reply: Nov 29, 2017 9:33 AM by Kaushik Solanki RSS

    NULL FIELD PROBLEM IN SET ANALYSIS

    Caio Engelhardt Caminoski

      Hello community,

       

      I have a metric that uses a set analysis (  {<FIELD ={'Y'}>}  ) . My problem starts when all the values of my 'FIELD' are null. Qlik completely ignores that null is different than 'Y' and don't even bother evaluating the set analysis, giving me the total sum of the value field instead of 0.

       

      For example, in the script:

      TABLE:

      Load

      RowNo() AS CODE

          ,Null() AS DIM

          ,1 AS VALUE

      AutoGenerate 15;

       

      In the KPI:

      Sum( {< DIM = {'Y'} >} VALUE)

       

      As there is no data 'Y' in the field DIM i should be getting 0, but instead I am getting 15.

       

      Captura.PNG

       

      Any ideas?