topic Question involving Sum IF in QlikView

Question involving Sum IF

lucastro_123 — Sat, 16 Nov 2024 18:25:24 GMT

Hello guys!

I was trying to do a simple SUM IF in QLIKVIEW, but i'm having trouble...

What i want to do is creat a chart (label "Total" and with year and month as dimensions) and to sum all the points on the collumn "points" that should be consider (Consider?=1 at the "Consider?" collumn).

i tryed the =if(Consider?=1,Sum(Points)) but it didnt work... Any suggestions?

I've Attached the QVW and the excel file as base

Thanks!

Re: Question involving Sum IF

Saravanan_Desingh — Tue, 30 Jun 2020 19:14:33 GMT

Try this.

Sum(If(Consider?=1,Points))

Re: Question involving Sum IF

Vegar — Tue, 30 Jun 2020 19:19:44 GMT

I'm not able to examine your qvw hence I'm on a mobile device, but you could solve this by using set analysis. Like this :

Sum({<[Consider?] ={"1"} >} Points)