2 Replies Latest reply: Nov 28, 2012 9:28 AM by Nikolaos Kavroulakis RSS

    sum of flagged values

      Hi there experts,

       

      I am kind of new on Qlikview. I am trying to find the sum of the percentage of values whith a specicic flag in my document. I tried sum(total Flag * percentage)

      buts did not work.Any ideas. The Flag and the percentage are complex expresion calculated in the straight table.See attached file.Thank you in advance

        • Re: sum of flagged values
          Gysbert Wassenaar

          You can't use column names in other expressions if you use aggregations. So an expression Flag*Percentage will return a result for the rows, but not for the total. You can set the Total Mode to Sum of Rows to get a total of sum of the values in the rows. If you need to do aggregations you'll need to use the expressions you created for Flag and Percentage instead of the column names (= expression labels)