Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

set analysis - table

hi i have a table-

Capture.PNG.png

because of the set analysis in column(6) i see in the table all the product types (first column) .

i want to see only the type with the full data (if i removing the set analysis in the 6 expression its show only the products type i want)

hope im clear...

1 Solution

Accepted Solutions
michael_maeuser
Partner Ambassador
Partner Ambassador

add an additional sum before your aggr, sum(aggr(sum...)

View solution in original post

11 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Please write your set analysis and explain your needed conditions

upaliwije
Creator II
Creator II

Please write your set expression to have look at

Not applicable

no, you are not clear

MK_QSL
MVP
MVP

Can you be more specific in your requirements?

adiarnon
Creator III
Creator III
Author

my table with the set analysis expression-

Capture.PNG.png

my table without the set analysis expression-

Capture1.PNG.png

the set analysis expression make the table to include all the values of the dimension.

i want the date of the table with the set analysis expression but to see only part of the values of the dimension

(like in the second table)

its hard for me to explain...

adiarnon
Creator III
Creator III
Author

can someone help?

Not applicable

include your expression into a aggr() function

aggr(sum{set analysis} measure), dim1, dim2)

where dim1 and dim2 are the dimension (in that order) of your table

Fabrice

adiarnon
Creator III
Creator III
Author

tnx,

its working.

but is there a way to see the partial sum (totals?)...

Capture.PNG.png

michael_maeuser
Partner Ambassador
Partner Ambassador

add an additional sum before your aggr, sum(aggr(sum...)