9 Replies Latest reply: Sep 29, 2015 5:11 AM by Simen Kind Gulbrandsen RSS

    How to show NULL in set analysis

    Darri Hilmarsson

      Hi QlikView

       

      I got one problem I have been trying to find solution to.

       

      this is my dataset.

       

      Sales PersonType CompanyRevenue
      Bill1Ferrari   100.000    
      John1Audi   250.000    
      David1Porche   300.000    
      Stuart2Fiat   450.000    
      Bond2Volvo   125.000    
      NULLNULLTesla   130.000    
      NULLNULLVW   280.000    
      James2Ferrari    150.000    
      Barry2Audi   500.000    

       

      In my data set I have different Sales Person for company because the Sales Person can be different type

      Sometimes I have NULL in the Sales Person and type.

       

      What I am trying to solve is making a straight table that shows only information that has type 1 and Null (exclude 2)

      I have been trying to use set analysis but I have problem regarding NULL.

       

      I want the view to look like this

       

        

      Sales PersonType CompanyRevenue
      Bill1Ferrari   100.000    
      John1Audi   250.000    
      David1Porche   300.000    
      NULLNULLTesla   130.000    
      NULLNULLVW   280.000