Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question to Set Analysis

Hello at all,

i need help. I´m a newbie to Set Analysis. I want the sum from Customers which have bought

one or more Articels from a Group.

Here my example which doesn´t work:

sum({<Artikel.Family={1,2,3,4}>#Kunden)

#Kunden: is a flag with 1 inside to count it up

Artikel.Family: Inside these are some numbers from 1-etc. (Group)

What do i make wrong in the function?

Greets

1 Solution

Accepted Solutions
Not applicable
Author

=Sum({$<Artikel.Family={$(=GetFieldSelection("Artical"))}>}#Kundan)

in this (=GetFieldSelection("Artical") will be Your selected articals.

View solution in original post

6 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

I don't think you need a flag. Can you tell me how your tables structure is? you can count directly the the cUstomer ID

Not applicable
Author

Hello,

yes i can make it so

sum(#Kunden)

then i get the Customer, but i want to display some different values for Customer.

I want to show Customer who bought in Group 1,2,3,4 and in 10 and so one, so i had

to make a function or not? I would show it in a table diagramm.

Greets

Not applicable
Author

=Sum({$<Artikel.Family={$(=GetFieldSelection("Artical"))}>}#Kundan)

in this (=GetFieldSelection("Artical") will be Your selected articals.

Not applicable
Author

Thank you, thats right, and a last question. Where i have to use an "AND" operator when i want to show

the sum of Customer when they have bought for example in the group 1 and 10?

Greets to all of you

jvitantonio
Luminary Alumni
Luminary Alumni

Just select only articles 1 and 10

Not applicable
Author

Your right oh my god