0 Replies Latest reply: Jun 13, 2016 6:41 AM by Anders Haugaard RSS

    Match data with different conditions

    Anders Haugaard

      Hi all,

      I am totally new to Qlik Sense. Infact my scripting experince is near to zero. I har two datasources, where I need to measure the data consistency.

      DataSources.png

       

      First thing what I have done - in Qlik - is to put together "Bygningsnavn" and Areal (Netto), so I have the unique ID.

      IDScript.png

      UniqueID.png

       

      Here comes the challenge. I need collections of:

      • All columns match,
      • Where "RUM NR." and "Rum nr" match, but where "Areal (netto)" and "Areal" do not match,
      • Where Nothing match from data source "Alle bygninger - Revit",
      • Where Nothing match from data source "Alle bygninger - DTUfm".

       

      Then I would like to show Pie Chart of every "Bygningsnavn" with the condition of the four different sets, as above.

       

      Hope you can hekp me, I will appreciate very much!

       

      Thanks!

       

      Anders Haugaard