chart aggregation

Anonymous — Tue, 10 Mar 2015 16:26:39 GMT

Hi folks,

the application of my customer is showing service requests and their eradication. In concret the customer is getting a list each month of open requests. The requirement is to show a chart by month and how often service requests are still open.

When I have the service requests as dimension and the following formula in expression

class(count({<Dat1=>}Request),2)

I get the number of stays in the class.

I want the classes (how long requests stay open 1,2,3..) as dimension (the customer is only interested if the requests arises or are reduced month by month)

Is this possible on the surface? I know how to manage this on the script level (and then the class function in the dimension works as well). As I have not only the service request but other fields as well, I would like to avoid the work on script level

Any ideas?

Re: chart aggregation

marcus_sommer — Tue, 10 Mar 2015 16:34:27 GMT

To use it as dimension you need an additionally aggr():

class(aggr(count({<Dat1=>}Request), YourDimension),2)

- Marcus

topic chart aggregation in QlikView

chart aggregation

Re: chart aggregation