topic distiction and summerize in QlikView

distiction and summerize

Wed, 12 Oct 2011 20:09:01 GMT

My goal is always enable to summerize the total hour by using the code sum(working hour) in the expressen after you have made a filtration of distincting CustomerID. In other word, make a distinction of the CustomerID and then summerize the working hour in the expressen. Everything should take place in the chart to display visual statistic. How shall I do it? Is it possible?

Table customer with fields:

CustomerID

first name

last name

city

working hour

// fullmetalboy

distiction and summerize

swuehl — Wed, 12 Oct 2011 20:16:38 GMT

Hi Jimmy,

hope I got it correctly, I think what you need is to create e.g. a straight table chart object with dimension CustomerID

and expression

=sum(working hour)

You could of course change the chart object to e.g. bar chart or soemthing else.

Hope this helps,

Stefan

Re: distiction and summerize

Thu, 13 Oct 2011 05:19:00 GMT

here is the attach excel sheet and qvw file based on you query. I think it solves your problem.