Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

calculate Amount base on Type

I want to calculate Amount base on Type I choose. My function is:

SUM({<Type={"=GetFieldSelections(Type)"}>}Amount)

But it only gives back 0. How can I modify it?

Thanks in advance!!

1 Solution

Accepted Solutions

Re: calculate Amount base on Type

This should already do this... why do you need a set analysis here?

Sum(Amount)

3 Replies

Re: calculate Amount base on Type

This should already do this... why do you need a set analysis here?

Sum(Amount)

wanyunyang
Contributor

Re: calculate Amount base on Type

You are right...I'm asking a stupid question...pls just ignore me.

hamza99a
Contributor

Re: calculate Amount base on Type

i agree with sunny. If you wanted a specific account type you could do:

if(sum account type='business',[Field you want to sum])

Community Browser