Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
lucastro_123
Contributor III
Contributor III

Question involving Sum IF

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!

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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)

View solution in original post

2 Replies
Saravanan_Desingh

Try this.

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

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)