Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

stvn_003
New Contributor II

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

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)

Community Browser