Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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!

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Question involving Sum IF

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
Specialist III
Specialist III

Re: Question involving Sum IF

Try this.

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

Re: Question involving Sum IF

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post