topic Re: Expression using when-statement in QlikView https://community.qlik.com/t5/QlikView/Expression-using-when-statement/m-p/573036#M1111447 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>=if(sum(Value)&gt;30, sum(Value))</P><P></P><P>With the way Qlikview works with selections, if you select 3, 4, 7, 10, sum(Value) will give 24. If you select 1, 2, 3, sum(Value) will give 6.</P><P></P><P>What kind of graph do you plan on doing with what dimensions? It may be possible to incorporate set analysis if they are dimensions involved. If this doesn't help, can you explain more or post a sample app demonstrating your problem?</P><P></P><P>Hope this helps!</P></BODY></HTML> Wed, 26 Feb 2014 15:11:04 GMT jerem1234 2014-02-26T15:11:04Z Expression using when-statement https://community.qlik.com/t5/QlikView/Expression-using-when-statement/m-p/573035#M1111446 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Lets say i have a listbox consisting of different values.</P><P></P><P>I want to make a graph, showing the sum of these value when they are over 30.</P><P></P><P>How do i write that in a expression?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 26 Feb 2014 15:00:32 GMT https://community.qlik.com/t5/QlikView/Expression-using-when-statement/m-p/573035#M1111446 2014-02-26T15:00:32Z Re: Expression using when-statement https://community.qlik.com/t5/QlikView/Expression-using-when-statement/m-p/573036#M1111447 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>=if(sum(Value)&gt;30, sum(Value))</P><P></P><P>With the way Qlikview works with selections, if you select 3, 4, 7, 10, sum(Value) will give 24. If you select 1, 2, 3, sum(Value) will give 6.</P><P></P><P>What kind of graph do you plan on doing with what dimensions? It may be possible to incorporate set analysis if they are dimensions involved. If this doesn't help, can you explain more or post a sample app demonstrating your problem?</P><P></P><P>Hope this helps!</P></BODY></HTML> Wed, 26 Feb 2014 15:11:04 GMT https://community.qlik.com/t5/QlikView/Expression-using-when-statement/m-p/573036#M1111447 jerem1234 2014-02-26T15:11:04Z