Calculation in straight table

[#1]

Dear Community,

As shown in the sample document, how can show a new column where its available= 1 and sum of that particular type?

so I would like to see sum of typeA, 3+4+3 = 10, sum of typeB = 4 and so on...

Thanks and best regards,

Chanel

[#2]

Sorry,  Try this one.  It does fit the sample data but may not easily scale to fit your full data set...

If(F1='TypeA',sum({<F1={'TypeA'}>}TOTAL F2*F3),

If(F1='TypeB',sum({<F1={'TypeB'}>}TOTAL F2*F3),sum({<F1={'TypeC'}>}TOTAL F2*F3)))

[#3]

Try this

=Aggr(Sum(F2*F3),F1)

[#4]

oops!! strangely the symbol got converted, you can try the below modified expression:

=If(F1='TypeA' and available='1', Sum({<F1={'TypeA'}>}TOTAL F2*F3),
If(F1='TypeB' and available = '1',Sum({<F1={'TypeB'}>}TOTAL F2*F3)))

This will not show anything in the rows where available is not 1, you can add 0 or '-' per you requirement.

Hope this helps!

[PrashantSangle]

Hi,

Check attached File,

Regards,

[qlikpahadi07 · Accepted solution]

Hi chanel,

I am not sure why you need such output where you can easily get with partial sum features.

anyways PFA I have done in all 3 forms may be helpful for you.

[lironbaram]

have a look at the attachment