Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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
Specialist III
Specialist III

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
Specialist III
Specialist III

Just select only articles 1 and 10

Not applicable
Author

Your right oh my god