This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have table A
Department Income Type
Comp 100 A
IT 200 A
Mech 300 B
Prod 200 C
EnTC 100 B
and I want to show total of Income per type in another table B
So how can I show conditional sum of field from one table in another table
Try creating a dimension like:
And create a new table with this new created dimension and [Type] field
View solution in original post
A: load Your Table
load Sum(Income) as TotalIncome,TypeResident Agroup by Type;
Dimension : Type
Expression : Sum(Income)
=sum(distinct aggr(nodistinct sum([Income]),[Type])))