4 Replies Latest reply: Aug 11, 2018 10:59 AM by Mario Centeno RSS

    Sum if multiple Qlik Sense

    Mario Centeno

      I have the challenge, I have a field called "TIPOMEDICION" that has two values "official" and "backup", I am using the dimension called "PUNTOSIMEC".


      It turns out that I have data from the official pointsimec and backup, but sometimes I only have data from the official and not from the backup or vice versa, the challenge is that when there is data in the official pointsimec I add the data, but if there is data that adds me the data of the Puntosimec backup.


      For this example I have two points loaded 40-4-81 & 40-82 but I do not have data from the official pointsimec of 40-4-82 but I need to add the data of the backup to complement.


      I hope you have made me understand.


      Current expression

      SUM(If([TIPOMEDICION] ='OFFICIAL' AND [KWHR]>0,[KWHR]/1000))

      simec.png

      simec2.png