topic Re: EXPRESSION need in QlikView

EXPRESSION need

sona_sa — Sat, 13 Mar 2021 09:38:05 GMT

Hi Team,

I have a two field, Family and Income. Below is structure:

FAMILY INCOME

A 10

B 20

C 15
C is Father and A and B is child. Now I want the sum of income where C will have total value and rest of child is his own income. Output is below :

FAMILY INCOME

C 45

A 10

B 20

How I can make an expression for this.

Regards,

Re: EXPRESSION need

Frank_Hartmann — Sat, 13 Mar 2021 11:12:58 GMT

If(FAMILY='C',sum(Total INCOME), sum(INCOME))

Re: EXPRESSION need

sona_sa — Sat, 13 Mar 2021 11:52:59 GMT

Hi Frank,

Thanks for reply,

I accept it, But I stuck here I have data year wise. Where D value is representing for every Year same figure. When I am clicking on Year, That time It is representing correct figure.

I attached my xls. for your reference.

Thanks

Re: EXPRESSION need

sona_sa — Sat, 13 Mar 2021 11:58:32 GMT

Hi Frank,

Thanks for reply,

I accept it, But I stuck here I have data year wise. Where D value is representing for every Year same figure. When I am clicking on Year, That time It is representing correct figure.

I attached my xls. for your reference.

Thanks

Re: EXPRESSION need

Frank_Hartmann — Sat, 13 Mar 2021 12:32:48 GMT

If(FAMILY='C',sum(Total <Year> INCOME), sum(INCOME))

Re: EXPRESSION need

sona_sa — Sat, 13 Mar 2021 12:37:29 GMT

Perfect.