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

    Match data with different conditions

      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.



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




      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!




      Anders Haugaard