topic Question to Set Analysis in QlikView

Question to Set Analysis

Thu, 23 Feb 2012 12:49:57 GMT

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

jvitantonio — Thu, 23 Feb 2012 12:53:01 GMT

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

Thu, 23 Feb 2012 12:55:59 GMT

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

Thu, 23 Feb 2012 12:57:14 GMT

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

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

Thu, 23 Feb 2012 13:07:38 GMT

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 — Thu, 23 Feb 2012 13:19:03 GMT

Just select only articles 1 and 10

Thu, 23 Feb 2012 13:24:12 GMT

Your right oh my god