Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
Try this.
Sum(If(Consider?=1,Points))
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)