Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

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
sunny_talwar

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

Sum(Amount)

View solution in original post

3 Replies
sunny_talwar

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

Sum(Amount)

wanyunyang
Creator III
Creator III
Author

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

hamza99a
Creator II
Creator II

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

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