0 Replies Latest reply: Jul 29, 2015 5:06 PM by Steven Saenz RSS

    Applying a filter to a sum (Aplicar un Filtro a una Suma)

    Steven Saenz

      Hello friends, what I have is a label where I show a sum, but that amount would put a condition to consider whether or not a group of values within that amount. Something like that:

      If (variable = 'YES', SUM (soles), (SUM (Suns) - SUM ({type = 'IGNORE'} Soles))

       

      If not the box in which framework if I want to consider whether or not corporate expenses in the sum (Current: 4)

      Assuming that expenditure is 1 if frame if the sum must be 4 if not the sum framework should be 3 (4-1 = 3)

      Screenshot_1.png

       

      Translated with Google Translate - Qlik Community Administrative Team

       

       

      Hola amigos, lo que tengo es un label en donde muestro una suma, pero a esa suma quisiera meterle una condicion, para considerar o no un grupo de valores dentro de esa suma. Algo asi:

      If(variable='SI',  SUM(soles),  (SUM(Soles) - SUM( {tipo='OMITIR'} Soles) )

       

      SI NO es la casilla en la que marco si quiero considerar o no los gastos corporativos dentro de la suma (Actual: 4)

      Suponiendo que los gastos sean 1, si marco si la suma debe ser 4 y si marco no la suma deberia ser 3 (4-1=3)