topic calculated dimension with class and set analysis in QlikView

calculated dimension with class and set analysis

Fri, 14 May 2010 00:46:57 GMT

Hi,

I want to do the following:
I have several jobs with several line items for different operations. For example I have Job number 1 and in here I have 3 line items for the operation MR with a value of 1 in each line. Basically a total of 3.

Now I want to have a calculated dimension, where I count the job (in attached file) which have values for MR in 2 or 4 or 6. I did that with the class formula:

=class(sum({<Operation={'MR'}>}Minutes),2)

But that doesn't work. Can somebody help?

Thanks in advance,

Oliver

calculated dimension with class and set analysis

johnw — Fri, 14 May 2010 01:12:25 GMT

You can't use aggregation functions in a calculated dimension without using aggr() and telling it what dimension(s) to aggregate across. In this case, you want to aggregate by Job (or more plainly, you want the sum of MR operation minutes for each job individually, not the grand total of all minutes in the whole system, and the way you do that is to aggregate by Job). So I think you want this:

aggr(class(sum({<Operation={'MR'}>}Minutes),2),Job)

It produces the graph I think you want, in any case.

calculated dimension with class and set analysis

Fri, 14 May 2010 01:17:19 GMT

Cool, that was exactly what I wanted.

Oliver