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)
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)